Use of INSTEAD OF Trigger in SQl SERVER
What is INSTEAD OF Triggers in Sql?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajeev KumarPosted Feb 27, 2023, 6:02 AM
The INSTEAD OF triggers are the DML triggers that are fired instead of the triggering event such as the INSERT, UPDATE or DELETE events. So, when you fire any DML statements such as Insert, Update, and Delete, then on behalf of the DML statement, the instead of trigger is going to execute. In real-time applications, Instead Of Triggers are used to correctly update a complex view.
Satyapriya NayakPosted Oct 19, 2012, 1:52 AM
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