我是菜鸟,简单的触发器问题,急。
lx47 2003-09-29 10:53:02 CREATE TRIGGER del ON dbo.CreditInsurance
FOR DELETE
AS
delete from Gatheringprawn
where Gatheringprawn.insurecode = (select insurecode from deleted)
CreditInsurance 是财务总表,Gatheringprawn是流水帐表
我想在总表每一次被删除一条记录后,都把他对应的流水帐全部删除,
这个触发器老是报错,说(select insurecode from deleted)的返回值不止一条。
请高人指点一二。