var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Question concerning triggers
Can anybody tell me how to translate the Oracle syntax :
"if inserting then" ?
Is it something like :
"if COLUMNS_UPDATED() <> NULL" ?
Another question concerning SQLServer triggers :
What is the equivalent of a "before" in SQLServer ?
Must I use 'INSTEAD OF" and then execute my insert ?
Look at the create trigger statement.
You can create a trigger for insert.
If you have an update, delete, insert trigger then the deleted virtual table will be empty.
Yes instead of is the equivalent of a before trigger.
In Oracle, we can have "before", "after" and "instead of"...
What is the difference ? Do we translate "before" like "instead of" ?
Thanks for help.
In sql server you get after and instead of.
If you want the trigger to fire before updating the table then create an instead of trigger.