CREATE TRIGGER tri_tb1 ON dbo.tb1 AFTER DELETE AS INSERT INTO dbo.tb2 ( col1, col2 ) SELECT col1,col2 FROM deleted GO
create table a(id int , name varchar(20)) go select * into b from a go create trigger a_del on a after delete as begin insert into b(id , name) select id , name from deleted end go insert into a(id ,name )values(100,'china') go select * from a go delete a go select * from a select * from b go
-- 能不用触发器,就别用咯。 -- 可以用以下方法。delete e OUTPUT DELETED.* INTO tablog from a e WHERE e.id='1';
delete from MyTable2 output deleted.* into MyTable1 where name = '燕郊'
deleted 临时表中有要删除的数据 直接插入 要插入的表中就可以了
AFTER DELETE
AS
INSERT INTO dbo.tb2 ( col1, col2 ) SELECT col1,col2 FROM deleted
GO
create table a(id int , name varchar(20))
go
select * into b from a
go
create trigger a_del
on a
after delete
as
begin
insert into b(id , name) select id , name from deleted
end
go
insert into a(id ,name )values(100,'china')
go
select * from a
go
delete a
go
select * from a
select * from b
go
-- 可以用以下方法。delete e
OUTPUT DELETED.* INTO tablog
from a e WHERE e.id='1';
output deleted.* into MyTable1
where name = '燕郊'