Updating clause used in instead of trigger example

Rated 3.83/5 based on 690 customer reviews

In SQL Server 2000 and onwards there are INSTEAD OF triggers that can be used to carry out such tasks.

Does it mean delete the LCR department from the dept_code table?Triggers created with FOR or AFTER keywords are both AFTER triggers.AFTER triggers do not work for views, so we will discuss the properties and functionality of INSTEAD OF triggers.The BEFORE or AFTER keyword determines when the trigger actions will be executed relative to the insertion, modification or removal of the associated row. The trigger can be called after the event, to record it, or take some follow-up action.

Leave a Reply