SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1196 Page Views: 

What is the purpose of INSTEAD OF Trigger in SQL SERVER?



Posted By: Avi Date: 1 October 2010 12:17:08 PM
 Answer:

INTEAD OF Triggers are the procedures whih are executed in place of a specific DML command which is related to the trigger. There are mainly 3 INSTEAD OF triggers viz. 1. INSTEAD OF DELETE 2. INSTEAD OF UPDATE 3. INSTEAD OF INSERT For eg. If an INSTEAD OF INSERT Trigger is applied on "stud" table then whenever the insert statement is executed it will not execute that statement but will fire the statements in the INSTEAD OF INSERT trigger.


Posted By: avibtech

Date: 1 October 2010 12:17:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image 8X6OTa
Related Questions
SQL Server : Which conditions are to be kept in mind while using the FOR BROWSE Option in SELECT statement?

Which conditions are to be kept in mind while using the FOR BROWSE Option in SELECT statement?

Following are the conditions:- 1. The table should have time-stamped column with timestamp as datat....
Category: SQL Server Date: 10/1/2010 11:29:07 AM
SQL Server : What is the purpose of FOR BROWSE option in the SELECT statement?

What is the purpose of FOR BROWSE option in the SELECT statement?

FOR BROWSE option which is used at the end of the SELECT statement allows the user to perform the up....
Category: SQL Server Date: 10/1/2010 11:28:07 AM
SQL Server : Which SQL statement doesn't support HOLDLOCK?

Which SQL statement doesn't support HOLDLOCK?

HOLDLOCK cannot be used with the SELECT statement which is having FOR BROWSE option.
Category: SQL Server Date: 10/1/2010 11:27:07 AM
SQL Server : What is HOLDLOCK in SQL?

What is HOLDLOCK in SQL?

HOLDLOCK option directs the SQL server to hold shared lock untill and unless the transaction is comp....
Category: SQL Server Date: 10/1/2010 11:26:07 AM
SQL Server : Discuss how Exclusive Locks are not compatible with other locks.

Discuss how Exclusive Locks are not compatible with other locks.

Exclusive Locks are not compatible with other lock types such as Shared Locks and Update Locks. Exam....
Category: SQL Server Date: 10/1/2010 11:25:07 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories