01 | CREATE trigger tr_bank3 ON bank3 |
02 | AFTER INSERT |
03 | AS |
04 | |
05 | |
06 | Update bank1 set bank1.fmoney=bank1.fmoney+c.a |
07 | From |
08 | ( select fid, sum ( case when TYPE=0 then fmoney when type=1 then -fmoney end ) as a From bank3 group by Fid) C |
09 | where |
10 | C.FID=bank1.FID |
11 | AND EXISTS( SELECT 1 FROM INSERTED WHERE Fid=bank3.Fid)) |
12 | |
13 | insert into bank1 |
14 | select |
15 | fid, |
16 | sum ( case when TYPE=0 then fmoney when type=1 then -fmoney end ) as a |
17 | from |
18 | bank3 AS a |
19 | WHERE |
20 | EXISTS( SELECT 1 FROM INSERTED WHERE Fid=a.Fid) |
21 | AND |
22 | NOT EXISTS( SELECT 1 FROM bank1 WHERE Fid=a.Fid) |
23 | group by Fid |