假设这个表有主键ID,而且不许修改:create trigger tri_update_lasetedittime
on table1
for insert,update
as
update table1
set lastedittime=getdate()
from table1,inserted
where table1.id=inserted.id
go
on table1
for insert,update
as
update table1
set lastedittime=getdate()
from table1,inserted
where table1.id=inserted.id
go
before insert or update on table1
for each row
begin
:new.lasetedittime:=sysdate();
end tr_bf_table1;
on table1
for update
as
update table1 set lastedittime=getdate()
很危险喔!