1. 'AFTER' Trigger should be fired once the all operations including constraints successfullt completed.
2. 'AFTER' Trigger is the default when 'FOR' is the only keyword specified.
3. 'AFTER' triggers cannot be specified on VIEWS
Here, I have created two triggers (Trg1, Trg2) on Table1. 'Trg1' Trigger used with 'AFTER' and 'Trg2' Trigger used with 'FOR'
CREATE TRIGGER TRG1 ON table1 AFTER INSERT AS
RAISERROR('This is After Trigger...!',10,1)
CREATE TRIGGER TRG2 ON table1 FOR INSERT AS
RAISERROR('This also After Trigger...!',10,1)
But, The both trigger created in same configuration...., Execute the script given below to identify the both triggers...
The result would be same... (Both are 'AFTER' trigger...)
trigger_name isupdate isdelete isinsert isafter isinsteadof
TRG1 0 0 1 1 0
TRG2 0 0 1 1 0
Conclution: So, we can not differentiate the 'AFTER' and 'FOR' (FOR just like keyword...)
CheersGopal_nivas, if this helps please login to Mark As Answer. | Alert Moderator