关于触发器更新数据库的问题

Question

update ORBaseOrderItem 
    set OOIAdjustOrderQty=OOIAdjustOrderQty-D.OOIOrderQty+E.OOIOrderQty
 from ORBaseOrderItem A,deleted D, inserted E
where A.OBOID=D.OBOID  and  A.BPCID=D.BPCID
  and A.OBOID=E.OBOID  and  A.BPCID=E.BPCID

Answer 1

CREATE TRIGGER Tg_updateAdjustOrderItemData ON dbo.ORBaseAdjustOrderItem
for update
ASupdate ORBaseOrderItem set OOIAdjustOrderQty=OOIAdjustOrderQty-D.OOIOrderQty from deleted D
where OBOID=D.OBOID  and  BPCID=D.BPCIDupdate ORBaseOrderItem set OOIAdjustOrderQty=OOIAdjustOrderQty+D.OOIOrderQty from inserted D
where OBOID=D.OBOID  and  BPCID=D.BPCID 
--- 觸發器處理UPDATE時，相當於先DELETE然後再INSERT，所以DELETED，INSERTED 表中都有數據可以參考。