After delete Trigger throw error：The row value(s) updated or deleted either do not make the row uniq

在after delete觸發器中執行update語句，更新另外一個表單資料

ALTER TRIGGER [dbo].[UpdateBookOfStudentFlag]
on [dbo].[tblBookInvoiceDetail]
AFTER DELETE
AS
BEGIN

update BookOfStudent set flag_orderUsed=0 where BookOfStudent.id = 52812--(select Book_ofStudent_Id from deleted)

END

 

表錯，提示受影響的行數多於1

The row value(s) updated or deleted either do not make the row unique or they alter multiple rows (2 rows).

 

 

簡單地在觸發器中設定

SET NOCOUNT ON即可

 

ALTER TRIGGER [dbo].[UpdateBookOfStudentFlag]
on [dbo].[tblBookInvoiceDetail]
AFTER DELETE
AS
BEGIN
SET NOCOUNT ON
update BookOfStudent set flag_orderUsed=0 where BookOfStudent.id = 52812--(select Book_ofStudent_Id from deleted)
SET NOCOUNT OFF
END