触发器判断更改的行或列

行:@@rowcount

列:@i ---列的索引号

if substring(columns_updated(),(@i-1)/8+1,1)&power(2,(@i-1)%8)>0

--------------------------------------------------------------------------------------------------------------------

得数数据库某表的列信息

select count(*)  as 列数 from sysobjects a join syscolumns b on a.id=b.id where a.name='tablename'

--------------------------------------------------------------------------------------------------------------------