Algorithm to Create Trigger In SQL Server

Posted in SQL | Triggers January 08, 2020
Tags: Trigger, create trigger, algorithm to create trigger, SQL Server 2012
In this article I describe algorithm to write trigger in SQL Server.
  • 2576

Trigger

Triggers in SQL are a special type of procedure that are executed, fired or invoked automatically in response to an action query are executed on a view or table.

Algorithm to Create Trigger In SQL Server

  2. CREATE [OR REPLACE ] TRIGGER trigger_name.
  3. {BEFORE | AFTER | INSTEAD OF }.
  4. {INSERT [OR] | UPDATE [OR] | DELETE}.
  5. [OF col_name].
  6. CREATE [OR REPLACE ] TRIGGER trigger_name.
  7. [ON table_name].
  8. [REFERENCING OLD AS o NEW AS n].
  9. [FOR EACH ROW].
  10. WHEN (condition). 

where,

trigger_name specifies the name of trigger you want to give.

before/after/instead of specifies types of trigger.

insted/update/delete specifies after which operation trigger should be fired.

table_name specifies the table name on which trigger is applied.

    © 2020 DotNetHeaven. All rights reserved.