Posted by dba_222 on 10/15/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!

[Back to original message]