After Delete trigger throw error: the row value (s) updated or deleted either do not make the row uniq

Execute the update statement in the after Delete trigger to update the data of another form.

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

 

Table error: the number of affected rows is more than 1

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

 

 

Simple settings in triggers

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