Difference between After and Instead Of Triggers in SQL Server

Описание: Click here to Subscribe to IT PORT Channel :    / @itport28  

After Triggers fire after the execution of an action query that can be either DDL statements like Create, Alter and Drop or DML statements like Insert, Update and Delete

Instead OF Triggers fire before the execution of an action query that can only be DML statements like Insert, Update and Delete but after the execution of that query. The table data will not be affected, in other words if you want to insert or update the data of the table then you need to write it in the trigger using "inserted" or "deleted" virtual tables