create trigger tr_tb on TB
for update,insert
as
ALTER TABLE TB DISABLE TRIGGER tr_tb--防止触发器递归
update a set datecolumn=getdate() from TB
a join inserted b on a.keycolumn=b.keycolumn
ALTER TABLE TB enable TRIGGER tr_tb--还原
假设该表存在有键列keycolumn
create trigger trigger_name on tablename
for update,insert
as
update a set datecolumn=getdate() from tablename a join inserted b on a.keycolumn=b.keycolumn