What is Trigger in SQL Server?

What is Trigger in SQL Server?

A trigger is especial type of Stored Procedure that executes when certain action performed on Table like:-

• Insert
• Delete
• Update

It’s a Database Object which is bound to a table and is executed automatically.

There are Two type of Trigger:-

• After Trigger(For Trigger)
• Instead of Trigger

After Trigger are divided into Three type:-

1. For Insert
2. For Delete
3. For Update

Instead of Trigger are divided into Three type:-

1. Instead of Insert
2. Instead of Delete
3. Instead of Update