COLUMNS_UPDATED() 究竟是什么数据

[xiangyyy]

COLUMNS_UPDATED() 出来的究竟是什么数据！二进制吗？那如果要只判断

表的第三行是否变化怎么写？

[caixia615]

if update(列名)
begin
....

[bugchen888]

/*Check whether columns 2, 3 or 4 has been updated. If any or all of columns 2, 3 or 4 have been changed, create an audit record. The bitmask is: power(2,(2-1))+power(2,(3-1))+power(2,(4-1)) = 14. To check if all columns 2, 3, and 4 are updated, use = 14 in place of >0 (below).*/

IF (COLUMNS_UPDATED() & 14) > 0
/*Use IF (COLUMNS_UPDATED() & 14) = 14 to see if all of columns 2, 3, and 4 are updated.*/
BEGIN

[xiangyyy]

要实际操作过啊，自带例子的不要。