create trigger uTrigger on MTLtable for insert,update,delete
asif exists(select * from deleted)
update MTLtable
set partqty = partqty + B.qty
from
(select partno , sum(partqty) as qty from deleted group by partno) As B
where MTLtable.partno = B.partno
if exists(select * from inserted)
update MTLtable
set partqty = partqty - B.qty
from
(select partno , sum(partqty) as qty from inserted group by partno) As B
where MTLtable.partno = B.partno
asif exists(select * from deleted)
update MTLtable
set partqty = partqty + B.qty
from
(select partno , sum(partqty) as qty from deleted group by partno) As B
where MTLtable.partno = B.partno
if exists(select * from inserted)
update MTLtable
set partqty = partqty - B.qty
from
(select partno , sum(partqty) as qty from inserted group by partno) As B
where MTLtable.partno = B.partno
如果更新怎么寫.
TRIGGER都是這樣處理的
即 UPDATE時,DELETED ,INSERTED表中都會有數據的