Use of INSTEAD OF Trigger in SQl SERVER

Question

What is INSTEAD OF Triggers in Sql?

Satyapriya Nayak · Answer

Hi Deepak Triggers are special kind of stored procedures that get executed automatically when an INSERT UPDATE or DELETE operation takes place on a table. Triggers can't be invoked on demand. They get triggered when the associated INSERT DELETE or UPDATE is performed. Please refer the below link http://www.codeproject.com/Articles/25600/Triggers-Sql-Server http://www.mssqltips.com/sqlservertip/1804/using-instead-of-triggers-in-sql-server-for-dml-operations/ http://sqlserverpedia.com/wiki/Triggers_-_INSTEAD_OF Thanks