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
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