Trigger In Sql Server


Trigger is a special kind of Store procedure Modifications to the table are made using INSERT,UPDATE OR DELETE trigger will run

It is automatically run

Triggers prevent incorrect , unauthorized, or inconsistent changes to data.

Syntax in Trigger:

CREATE TRIGGER trigger_name ON table_name
FOR [INSERT/UPDATE/DELETE] AS
IF UPDATE(column_name)
{AND/OR} UPDATE(COLUMN_NAME)...]
{ sql_statements }

Trigger Rules:

  • A table can have only three triggers action per table : UPDATE ,INSERT,DELETE.
  • Only table owners can create and drop triggers for the table.This permission cannot be transferred.
  • A trigger cannot be created on a view or a temporary table but triggers can reference them.
  • They can be used to help ensure the relational integrity of database.On dropping a table all triggers associated to the triggers are automatically dropped .

INSERT TRIGGER

  • When an INSERT trigger statement is executed ,new rows are added to the trigger table and to the inserted table at the same time. 
  • The inserted table allows to compare the INSERTED rows in the table to the rows in the inserted table.

DELETE TRIGGER

When a DELETE trigger statement is executed ,rows are deleted from the table and are placed in a special table called deleted table.

UPDATE TRIGGER

When an UPDATE statement is executed on a table that has an UPDATE trigger,

0 Comments

Featured Post

Improving C# Performance by Using AsSpan and Avoiding Substring

During development and everyday use, Substring is often the go-to choice for string manipulation. However, there are cases where Substring c...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts