The INSTEAD OF triggers execute instead of the original data modification

What does the INSTEAD OF trigger do?

Question Posted / s.vanitha

Answer Posted / s.vanitha

The INSTEAD OF triggers execute instead
of the original data modification. INSTEAD OF trigger are
allowed for both tables and views.

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

962

What is compression - row-level and page-level compression?

918

What is ssl in sql server?

1075

What does REVERT do in SQL Server 2005?

961

How to get a list of columns in a view using the "sp_help" stored procedure?

1033

Is natural join and equi join same?

972

Explain few of the new features of sql server 2008 management studio

920

How to convert numeric expression data types by assignment operations?

1081

What is msdb database? : SQL Server Architecture

1133

Explain the cursor lock types?

1054

Difference between DELETE and TRUNCATE?

1047

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

936

What is the difference between Triggers and Stored Procedure?

1096

What are the limitations/drawbacks or ssrs 2008 r2?

139

Explain the concepts and capabilities of sql server?

976