1：delete from tab2 where id in (select id from deleted) insert into tab2 select * from inserted 2： create table labtt ( id int identity(1,1), names varchar(80) ) go create table laburl ( id int identity(1,1), url varchar(200) ) insert into labtt(names) values('/upload/img/2001/1122.jpg') create trigger aa on labtt ( ) select * from labtt delete from labtt where id=2 delete from labtt where id in(6,7,5) select * from laburl alter trigger trsss on labtt for delete as begin insert into laburl(url) select names from deleted end