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
IOS