COLUMNS_UPDATED (Transact-SQL)

To test whether only column C2 is updated, specify & 2. COLUMNS_ UPDATED can be used anywhere inside a ...

msdn.microsoft.com