触发器中被更新了的列名.sql

来自「很好的sql 文档,可能邦你成为sql 高手」· SQL 代码 · 共 13 行

--显示触发器中被更新了的列名
create trigger tr_process on 表
after insert,update
as
select name
from syscolumns 
where id=object_id('表')
	and (substring(columns_updated(),(colid-1)/8+1,1)
		&power(2,(colid-1)%8))=power(2,(colid-1)%8)
order by colid
go