CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
ASupdate material set quantity =material.quantity-feedinme.quantity from feedinme,deleteed
where feedinme.receipt = deleteed.receipt and material.idno = feedinme.receiptdelete feedinme from deleted where receipt = deleted.receipt
FOR DELETE
ASupdate material set quantity =material.quantity-feedinme.quantity from feedinme,deleteed
where feedinme.receipt = deleteed.receipt and material.idno = feedinme.receiptdelete feedinme from deleted where receipt = deleted.receipt
唉!
pengdali(大力 V2.0)写的应该没错了
但还是报错:列名receipt不明确?
CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
ASupdate material set quantity =material.quantity-feedinme.quantity from feedinme,deleteed
where feedinme.receipt = deleteed.receipt and material.idno = feedinme.receiptdelete from feedinme where receipt in (select receipt from deleted)
FOR DELETE
AS
update material set quantity = quantity - feedinme.quantity from feedinme, deleted
where feedinme.receipt = deleted.receipt
and material.idno = feedinme.receipt
delete feedinme from deleted where feedinme.receipt = deleted.receipt
FOR DELETE
AS
update material set quantity = quantity - feedinme.quantity from feedinme, deleted
where feedinme.receipt = deleted.receipt
and material.idno = feedinme.receipt
delete feedinme from deleted where feedinme.receipt = deleted.receipt
如果在from后面带deleteed的话,语法就不报错,但真正删除的时候会出错
如果不带deleteed语法都不通过.
其实把from后的deleted换成其它东东比如.aaa,bbbb都可以,但是删除的时候报错对象名deleteed无效
唉!...好烦了..........