Skip to content
Home » sql trigger

sql trigger

SQL Triggers

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,438 total views