What is trigger in sql server?

Triggers allows us to execute a batch of SQL code when either an insert, update or delete command is executed against a specific table.

Triggers are special types of stored procedures that are defined to execute automatically in place of or after data modifications. They can be executed automatically on the insert, delete and update operation.
There are four types of triggers.
1. Insert
2. Delete
3. Update
4. Instead of

Leave a Reply