怎么会这样?

[beadly]

CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
AS
update material set quantity = quantity - feedinme.quantity from feedinme, deleteed
where feedinme.receipt = deleteed.receipt
and material.idno = feedinme.receipt
delete feedinme from deleteed where receipt = deleted.receipt
这样竟然不报错.
deleted==>deleteed
唉!http://expert.csdn.net/Expert/topic/2172/2172881.xml?temp=.9358484

[pengdali]

CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
AS

update material set quantity =material.quantity-feedinme.quantity from feedinme,deleteed
where feedinme.receipt = deleteed.receipt and material.idno = feedinme.receipt

delete feedinme from deleted where receipt = deleted.receipt

[zjcxc]

如果是在创建触发器的时候,不会报错是正常的.

如果是在被触发时能处理,则表明你的数据库中有deleteed这个表.

[zjcxc]

创建触发器的时候,只会检查是否有语法错误,不会检查引用的表是否存在的.

[beadly]

没有这个表!除非这是系统表.deleteed
唉!
pengdali(大力 V2.0)写的应该没错了
但还是报错:列名receipt不明确？

[zjcxc]

试试
CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
AS

update material set quantity =material.quantity-feedinme.quantity from feedinme,deleteed
where feedinme.receipt = deleteed.receipt and material.idno = feedinme.receipt

delete from feedinme where receipt in (select receipt from deleted)

[sdhdy]

CREATE TRIGGER howdele ON [dbo].[feedin]
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

[happy_0325]

CREATE TRIGGER howdele ON [dbo].[feedin]
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

[beadly]

楼上的各位还是不行.
如果在from后面带deleteed的话,语法就不报错,但真正删除的时候会出错
如果不带deleteed语法都不通过.
其实把from后的deleted换成其它东东比如.aaa,bbbb都可以,但是删除的时候报错对象名deleteed无效
唉!...好烦了..........

[beadly]

楼上的主要是扣数扣不到...