Skip to content
Home » what is the use of trigger in sql server

what is the use of trigger in sql server

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.

Loading