• CONVERT(int, COLUMNS_UPDATED() ) does not work

    columns_updated is 0xF2FF03

    the int value is 15924995

    the bin value is 11110010 11111111 00000011

    F2 FF 03

    But in fact i'm expecting

    int -> 262130

    bin -> 00000011 11111111 11110010

    03 FF F2

    if this case the updated columns are in position (non-zero based)

    2, 5-18

    00000000 00000000 00000010 [2]

    00000000 00000000 00010000 [5]

    00000000 00000000 00100000 [6]

    ...

    00000001 00000000 00000000 [17]

    00000010 00000000 00000000 [18]