all types of triggers in sql server

SQL Server triggers are special kind of Stored Procedures that invokes whenever a special event in the database occurs.

SQL Server uses two virtual tables INSERTED and DELETED, whenever a trigger is called . These table is used to capture the data of the modified row before and after the event occurs  tables , these tables are called as magic tables or virtual tables.

 3,726 total views,  2 views today