1. UPDATE table_a set column_b=getdate() 2. 要建一个触发器: 要区分是否更新,要有一个标志列,假设为ID: 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
--第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
--第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
UPDATE table_a set column_b=getdate()
2.
要建一个触发器:
要区分是否更新,要有一个标志列,假设为ID:
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
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 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