---

Search posts under SQL Server:

---

SQL Server > Triggers

In this section we are going to learn about the Triggers in the SQL server.

Triggers

Triggers are special kind of stored procedure that executes only when the database table is modified using Data Manipulation Language (DML) SQL Statements (Either INSERT, UPDATE or DELETE).

There are following types of triggers

1. AFTER – executes after DML SQL statements
2. INSTEAD OF – this executes instead of actual DML statement

Read posts under SQL Server > Triggers

1. AFTER INSERT triggers
2. AFTER UPDATE triggers
3. AFTER DELETE trigger
4. Disable a trigger
5. Enable trigger
6. INSTEAD OF trigger