34,576
社区成员
发帖
与我相关
我的任务
分享
--第1问,但最好象第2问,指定一下更新了那些栏位需要更新column_d
create trigger tudpate_table_a
on dbo.table_a
for update
as
begin
if not update(column_d)
begin
update table_a
set column_d = getdate()
from inserted i
and i.主键 =table_a.主键
end
end
--第2问,
create trigger tudpate_table_a
on dbo.table_a
for update
as
begin
if update(column_c)
begin
update table_a
set column_d = getdate()
from inserted i,deleted d
where i.主键 = d.主键
and i.column_c <> d.column_c
and i.主键 =table_a.主键
end
end
create trigger upcold
on table_a
after update
as
begin
if update(column_c)
update table_a set column_d=getdate() where id in(select id from inserted)
end
go