sql server db trigger when certain field changes

Question

is there anyway to put a condition in a SQL server trigger to say fire when field "XYZ" changes ?

EDIT:

what is the correct SQL syntax to basically insert into a new field

Field XZY has changes from Value A to value B

Mladen Prajdic · Accepted Answer · 2010-01-07 00:19:16Z

2

the trigger will always fire but you can break it's execution by using UPDATE() and COLUMNS_UPDATED methods inside the trigger

answered Jan 7, 2010 at 0:19

Mladen Prajdic

15.7k2 gold badges46 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

msharp · Accepted Answer · 2010-01-07 00:51:50Z

2

you can have a conditional section anywhere within your trigger statement using

IF UPDATE (column_name)
BEGIN
    IF (SELECT column_name FROM INSERTED) = 'B'
    BEGIN
        /* do something */
    END
END

answered Jan 7, 2010 at 0:22

msharp

3,2562 gold badges21 silver badges6 bronze badges