mssql触发器示例 枫

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