34,590
社区成员
发帖
与我相关
我的任务
分享
delete from STN_Podet where SerialNo='1' and PONO='PUR090020'
delete from STN_Podet where SerialNo='2' and PONO='PUR090020'
update stn_pohd
set VenderId='Y006',DueDate='2009-08-27' , PODate='2009-08-11' ,CurrencyId='1',
PayTermId='0',TransModeId='3',ReceiveBy='-1',Amt='0' ,Notes='TEST' ,
PurchaseBy='0002',totalQty=0 where PONO='PUR090020'
delete from STN_Podet where SerialNo='1' and PONO='PUR090020'
delete from STN_Podet where SerialNo='2' and PONO='PUR090020'
ALTER TRIGGER [TRI_PODetDelete]
ON [dbo].[STN_PODet]
FOR Delete
AS
UPDATE STN_SubscribeDet SET
DeliveryQty = DeliveryQty - d.Qty
from deleted d
WHERE STN_SubscribeDet.SubscribeNo = d.SourceSerialNo AND STN_SubscribeDet.SerialNo= d.SourceNo
and d.SourceSerialNo >0
ALTER TRIGGER [TRI_PODetDelete]
ON [dbo].[STN_PODet]
FOR Delete
AS
UPDATE STN_SubscribeDet SET
DeliveryQty = DeliveryQty - i.Qty
from inserted i
WHERE STN_SubscribeDet.SubscribeNo = i.SourceSerialNo AND STN_SubscribeDet.SerialNo = i.SourceNo
and i.SourceSerialNo >0
ALTER TRIGGER [TRI_PODetDelete]
ON [dbo].[STN_PODet]
FOR Delete
AS
IF EXISTS(SELECT 1 FROM DELETED WHERE SourceSerialNo> 0)
UPDATE a SET DeliveryQty = DeliveryQty - d.Qty
FROM STN_SubscribeDet a,DELETED d --少了个D,补充一下
WHERE a.SubscribeNo = d.SourceNo AND a.SerialNo = d.SourceSerialNo
GO