SQL Server trigger that fires only on update of certain field?

Giganews Newsgroups
Subject: SQL Server trigger that fires only on update of certain field?
Posted by:  dba_2…@yahoo.com
Date: 14 Aug 2006

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!

Replies