导入数据时, 存在的更新, 不存在的插入
- 作者: 苏晴儿说我特别能干
- 来源: 51数据库
- 2022-08-17
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
推荐阅读
