var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: FOR and AFTER
Someone pls enlighten me...
I understand that FOR TRIGGERS would be executed concurrently as the table is being updated/inserted/deleted
AFTER TRIGGER would only be executed after the UPDATE/INSERT/DELETE operation has been completed....am i right?
I never heard of FOR TRIGGERS. I only know about
BEFORE TRIGGER (not supported by MSSQL, as far as I know)
INSTEAD OF TRIGGER
Where did you hear about FOR triggers ?
ok sorry i didn't mean FOR triggers..
what i meant was ..whats the difference between the following 2.
ALTER TRIGGER SendMsgs ON asiapac702_test.dbo.tblCustServiceHistoryHdr FOR UPDATE
ALTER TRIGGER SendMsgs ON asiapac702_test.dbo.tblCustServiceHistoryHdr AFTER UPDATE
Ok, now I get it.
As far as I can understand from the documentation, FOR and AFTER are synonyms, from a syntax point of view.
I did some testing, and found no differences between
create trigger tai_t on t FOR insert as begin select 1 end
create trigger tai_t2 on t AFTER insert as begin select 1 end
Probably this has something to do with being ANSI/ISO or whatever compliant.