CREATE TRIGGER del ON dbo.CreditInsurance
FOR DELETE
AS
SET NOCOUNT ON
delete from Gatheringprawn
where Gatheringprawn.insurecode = (select insurecode from deleted)
FOR DELETE
AS
SET NOCOUNT ON
delete from Gatheringprawn
where Gatheringprawn.insurecode = (select insurecode from deleted)
subquery returned more than 1 value
this is not permitted when the subquery fallows = <,<=,>=.>
or the subquery is uesed as an expression
FOR DELETE
AS
delete Gatheringprawn
where Gatheringprawn.insurecode in (select insurecode from deleted)
还是报错:
subquery returned more than 1 value
this is not permitted when the subquery fallows = <,<=,>=,>,!=
or the subquery is uesed as an expression
到底是什么原因呢?应该没有其他因素的影响啊,我只是在数据库中写了这个TRRIG,然后在另一个表里(CreditInsurance )删除一条记录啊
这个DELETED到底是代表什么呢?
try:
CREATE TRIGGER del ON dbo.CreditInsurance
FOR DELETE
AS
set nocount on
delete Gatheringprawn from deleted where Gatheringprawn.insurecode = deleted.insurecode
FOR DELETE
AS
set nocount on
delete from Gatheringprawn
where insurecode in (select insurecode from deleted)