22,300
社区成员




create table abc( A int, B varchar(10), C varchar(10))
insert into abc
select 1 ,'A1', 'A1' union all
select 2 ,'A1', 'B3' union all
select 3 ,'A1', 'B4' union all
select 4 ,'A1', 'B5' union all
select 5 ,'A1', 'B6'
create table cde(b varchar(10))
insert Into cde
select 'A1' union all
select 'A2' union all
select 'A1'
go
--建立delete触发器
create trigger dbo.trigger_abc_delete
on dbo.abc
after delete
as
delete cde
from deleted d
where cde.b = d.b
go
--执行delete语句,触发delete触发器
DELETE FROM ABC WHERE B='A1'
--都delete了
select *
from abc
--删除了b等于A1的记录
select *
from cde
/*
b
A2
*/