<div>
For the question log:<br />
<br />
An easy way to determine the &quot;&nbsp;power(2, (n-1)) &quot;&nbsp; value is to print the SUBSTRING(COLUMNS_UPDATED(<wbr />),n,1 and then convert this hexadecimal value to decimal and then work from there...<br />
<br />
The code would look loke this:<br />
<br />
IF (SUBSTRING(COLUMNS_UPDATED<wbr />(),1,1)=20<wbr />) -- &nbsp;Columns 3 and 5 (2^2 + 2^4)<br />
&nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; AND (SUBSTRING(COLUMNS_UPDATED<wbr />(),2,1)=1)<wbr /> -- Column 9 &nbsp; (Second group, 2^0)<br />
&nbsp; &nbsp; &nbsp; ) <br />
<br />
<br />
I think it's easier to read this way.
</div>


For the question log:

An easy way to determine the " power(2, (n-1)) "  value is to print the SUBSTRING(COLUMNS_UPDATED(),n,1 and then convert this hexadecimal value to decimal and then work from there...

The code would look loke this:

IF (SUBSTRING(COLUMNS_UPDATED(),1,1)=20) --  Columns 3 and 5 (2^2 + 2^4)
     
      AND (SUBSTRING(COLUMNS_UPDATED(),2,1)=1) -- Column 9   (Second group, 2^0)
      )


I think it's easier to read this way.

<div>
<div class="content wysiwyg-content">
I have a trigger that runs after update on a table. <br />
<br />
Microsoft tells that the way to determine witch column was modified is to use<br />
<br />
IF COLUMNS_UPDATED() &amp;&nbsp;ColumnNumber &gt;&nbsp;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 &amp;&nbsp;does not work.<br />
<br />
Does anybody now a way around this?<br />
<br />
Thanks in advance,<br />
Roberto.
</div>
</div>


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,
Roberto.

How to determine witch column was updated during a trigger if the COLUMNS_UPDATED() is larger then the integer value

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.