导入数据时, 存在的更新, 不存在的插入 无 CREATE?trigger?tr_bank3?ON?bank3AFTER?INSERTAS??????Update?bank1?set?bank1.fmoney=bank1.fmoney+c.a???????From?????????(select?fid,sum(case?when?TYPE=0?then?fmoney?when?type=1?then?-fmoney?end)?as?a?Fr
导入数据时, 存在的更新, 不存在的插入CREATE?trigger?tr_bank3?ON?bank3 AFTER?INSERT AS ? ? ????Update?bank1?set?bank1.fmoney=bank1.fmoney+c.a? ??????From? ????????(select?fid,sum(case?when?TYPE=0?then?fmoney?when?type=1?then?-fmoney?end)?as?a?From?bank3?group?by?Fid)?C? ????where? ????????C.FID=bank1.FID? ????????AND?EXISTS(SELECT?1?FROM?INSERTED?WHERE?Fid=bank3.Fid)) ? ????insert?into?bank1? ????select? ????????fid, ????????sum(case?when?TYPE=0?then?fmoney???when?type=1?then?-fmoney?end)?as?a? ????from? ????????bank3?AS?a ????WHERE? ????????EXISTS(SELECT?1?FROM?INSERTED?WHERE?Fid=a.Fid) ????AND? ????????NOT?EXISTS(SELECT?1?FROM?bank1?WHERE?Fid=a.Fid) ????group?by?Fid
MERGE [target] t using [source] s on t.id = s.id when matched then update t.name = s.name, t.age = s.age -- use "rowset1" when not matched then insert values(id,name,age) -- use "rowset2" when source not matched then delete; -- use "rowset3"
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
广告
收藏
收藏
收藏
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
888
取消收藏
