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

How to delete all rows with truncate table statement in ms sql server?

929

What are the properties of sub-query?

1024

What is the difference between DataRow.Delete() and DataRow.Remove()?

1166

Explain difference between cross join and full outer join?

953

What are the joins in sql server? : sql server database administration

962

What is rtm version in sql server?

978

How to delete duplicate rows from table except one?

931

Can two tables have the same primary key?

1133

Give the query of getting last two records from the table in SQL SERVER?

899

What is optimization and its types?

912

How many categories of data types used by sql server?

967

List out the difference between union and union all in sql server?

919

What is resource governor in sql server?

947

Where to find ntwdblib.dll version 2000.80.194.0?

920

What is transact-sql language?

1006