SQL Server > Triggers

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

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



Write for us






Hosting Recommendations