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
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
the trigger will always fire but you can break it's execution by using UPDATE() and COLUMNS_UPDATED methods inside the trigger