create trigger t_in on yourtable for insert as select code from inserted go create trigger t_da on yourtable for delete as select code from deleted go create trigger t_up on yourtable for upate as select code from inserted select code from deleted go
for insert
as
select code from inserted
go
create trigger t_da on yourtable
for delete
as
select code from deleted
go
create trigger t_up on yourtable
for upate
as
select code from inserted
select code from deleted
go
当前删除的记录在系统的deleteed表中