执行insert的时候 给一列重新赋值这个时候不是重新赋值吧?大致为:create trigger my_trig on tb for insert as begin update tb set dt = getdate() --时间 where id = (select id from inserted) end
这一列是另一个表的一列吗? create trigger tri_update_tb on ta for insert as begin update b set date= getdate() from tb b, inserted i where b.id = i.id nd
--同表的话可以用instead of 来代替操作create trigger tr_test on tb instead of insert as insert tb(collist,datecol) select collist,getdate() from inserted go
as
begin
update tb set dt = getdate() --时间
where id = (select id from inserted)
end
create trigger tri_update_tb
on ta
for insert
as
begin
update b set date= getdate() from tb b, inserted i
where b.id = i.id
nd
instead of insert
as
insert tb(collist,datecol)
select collist,getdate() from inserted
go
set @dt = getdate()