|
|
Posted by dba_222 on 06/12/08 11:55
Dear Experts,
I'm an Oracle guy, who is being given more SQL Server assignments
lately.
I've been looking for things on the web about this, but I can't
anything so far.
In Oracle, I you can create a trigger on a table that -only- fires if
certain fields are updated.
create or replace trigger trg_some_trigger
BEFORE insert
OF some_field1, some_field2
on tbl_some_table
for each row
....
Is this also possible in SQL Server?
What is the syntax please?
Thanks a lot!
Navigation:
[Reply to this message]
|