SQL trigger delete and update operations

Compile the trigger:

The code is as follows:	Copy code
Create trigger BlogDelet On Blog Instead of delete As Delete from Comment Where CommentBlog in (select Id from deleted)

Create an Update trigger:

The code is as follows:	Copy code
Create Trigger truStudent On Student -- create a trigger in the Student table For Update -- why events are triggered As-what to do after an event is triggered If Update (StudentID) Begin Update BorrowRecord Set StudentID = I. StudentID From BorrowRecord br, Deleted d, Inserted I -- Deleted and Inserted temporary tables Where br. StudentID = d. StudentID End

 

For more details about SQL triggers, refer to the http://www.111cn.net/database/mssqlserver/39336.htm