通过触发器进行的操作
删除操作前,先备份一下
--触发器生成 CREATE trigger [detail_delete] on [dbo].[yy_detail] instead of delete --for delete as begin insert into bak_yy_detail select * from deleted --where id=@@identity delete from yy_detail where id in(select id from deleted) end
Deleted 表是用于存储 DELETE 和 UPDATE 语句所影响的行的复本的临时表,在执行 DELETE 或 UPDATE 语句时,行从触发器表中删除,并传输到 deleted 表中。Deleted 表和触发器表通常没有相同的行。
Inserted表用于存储INSERT和UPDATE语句所影响的行的副本。在一个插入或更新事务处理中,新建行被同时添加到inserted表和触发器表中。Inserted表中的行是触发器表中新行的副本。