I have a trigger that runs after update on a table.
Microsoft tells that the way to determine witch column was modified is to use
IF COLUMNS_UPDATED() & ColumnNumber > 0 . My problem is that due to the number of columns on this table the ColumnNumber is 8589934592. This number is bigger than the integer value and if I cast it as a BigInt the bitwise operator & does not work.
Does anybody now a way around this?
Thanks in advance,