从表单价和数量引发主表的总价变化

use CNData
go

Create Trigger AddPrice
ON dbo.Te_Purchasea
AFTER INSERT
AS
UPDATE dbo.Te_Purchase
SET Sum_Price = Sum_Price + inserted.Price * inserted.Req_Pur_Qty
from inserted,Te_Purchase
where inserted.Pur_No = Te_Purchase.Pur_No
go

Create Trigger UpdatePrice
ON dbo.Te_Purchasea
AFTER UPDATE
AS
if(UPDATE(Price) OR UPDATE(Req_Pur_Qty))
begin
  UPDATE dbo.Te_Purchase
  SET Sum_Price = 0
  from inserted
  where inserted.Pur_No = Te_Purchase.Pur_No
  
  UPDATE dbo.Te_Purchase
  SET Sum_Price = Sum_Price + Te_Purchasea.Price * Te_Purchasea.Req_Pur_Qty
  from inserted,Te_Purchasea
  where inserted.Pur_No = Te_Purchase.Pur_No
        and inserted.Pur_No = Te_Purchasea.Pur_No
end
go

简单思路 :  插入直接累加就好了 如果是更新就要先清空再重新计算