|Subject:||SQL Server trigger that fires only on update of certain field?|
|Date:||14 Aug 2006|
I'm an Oracle guy, who is being given more SQL Server assignments
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
OF some_field1, some_field2
for each row
Is this also possible in SQL Server?
What is the syntax please?
Thanks a lot!