13,825
社区成员
发帖
与我相关
我的任务
分享
create trigger trigger_name
on table_name
for insert,update
as
begin
SET NOCOUNT ON;
update table_name set update_time = getdate()
from table_name,inserted
where table_name.relation_field = inserted.relation_field
SET NOCOUNT OFF;
end