Post reply

Combining triggers

  • June 12, 2006 at 1:05 am

    #90223

    I have two triggers for a table one for insert and one for update. Is there are any way to combine these triggers to a single trigger.

    Thanks

    Biju.

     

  • June 12, 2006 at 4:36 pm

    #643254

    Yes, when creating the trigger use FOR INSERT,UPDATE.  If different logic is dependant upon what type of statement is executed, INSERT vs UPDATE, use the below T-SQL to execute statement type specific logic.

    CREATE TRIGGER trTestTrigger ON tblTest

    FOR INSERT,UPDATE,DELETE

    AS

    DECLARE @iStmntType INT

    SET @iStmntType = 0  /* 1=Delete;2=insert;3=update */

    IF EXISTS(Select * from deleted) SET @iStmntType = @iStmntType + 1

    IF EXISTS(Select * from inserted) SET @iStmntType = @iStmntType + 2

    IF @iStmntType = 1

     -- Perform delete logic (More than one command use BEGIN ... END)

    IF @iStmntType = 2

     -- Perform insert logic (More than one command use BEGIN ... END)

    IF @iStmntType = 3

     -- Perform update logic (More than one command use BEGIN ... END)

    Also check into using IF UPATED(column_name) and COLUMNS_UPDATED Logic

    Jason

    -

  • June 13, 2006 at 1:09 am

    #643292

    Thank you very much Jason , I have tried it and its worked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply