CODEWITHSUNDEEP
sql-servertriggers
leora
leora

Reputation: 196499

sql server db trigger when certain field changes

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

Upvotes: 1

Views: 3602

Answers (2)

msharp
msharp

Reputation: 3208

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

Upvotes: 2

Mladen Prajdic
Mladen Prajdic

Reputation: 15677

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

Upvotes: 2

Related Questions