What do you mean by INSTEAD OF and AFTER Triggers.?

What do you mean by INSTEAD OF and AFTER Triggers.?

There are many diff are in INSTEAD OF and AFTER Triggers in SQL Server 2000. Which is following here : 
> INSTEAD OF triggers are bassically work on instead of the INSERT, UPDATE or DELETE triggering action. But in case of �AFTER� triggers are work on after the triggering actions.

By:UMANG
Date:2014-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher