IF UPDATE() in SQL server trigger

It returns true if a column was updated. An update means that the query has SET the value of the column. Whether the previous value was the same as the new value is largely irelevant.

UPDATE table SET col = col

it’s an update.

UPDATE table SET col = 99

when the col already had value 99 also it’s an update.

Leave a Comment