After Triggers in SQL SERVER 2005 and After Trigger Syntax

After Triggers run after an insert, delete and update.Views are not supported After Triggers.
    After Triggers can be classified into 3 types.
    1.AFTER INSERT Trigger
    2.AFTER UPDATE Trigger
    3.AFTER DELETE Trigger
   
    Syntax : AFTER INSERT Trigger
    CREATE TRIGGER trgAfter ON [dbo].[Table_Name]
    FOR INSERT /*Here we can use UPDATE or DELETE also for AFTER UPDATE and AFTER DELETE Triggers*/
    AS
                 -- write some logic
    PRINT 'AFTER Trigger fired.'
    GO

No comments:

Post a Comment