invoking trigger on column update

Question

Hi all,

I have a condition where in a trigger should be invoked whenever a particular column gets updated in a table but not when any other column gets updated. Is it possible?

Answer 1

Your trigger gets invoked on any update, but you can add some checking to process data only when your column has new value.

Answer 2

Hi, trigger has only tree options ON INSERT, UPDATE, DELETE this means trigger will ge fired on every update command no mater what column is updated Best Regars, Iordan

Answer 3

http://benreichelt.net/blog/2005/12/13/making-a-trigger-fire-on-column-change/

Answer 4

A trigger gets invoked regardless of the fields changed, however you can use

IF UPDATE(mycol)
BEGIN
    -- logic goes here
END

to implement logic for a specific column.

Also take a look at COLUMNS_UPDATED function too.