34,588
社区成员
发帖
与我相关
我的任务
分享
-2005
delete from a output deleted.BID
--2
create trigger triname on a
for delete
as
delete b
from deleted a,b b
where a.bid=b.bid
create table a(aid int,bid int)
create table b(bid int)
insert a select 1,1
insert a select 1,2
insert a select 1,3
insert b select 1
insert b select 2
create trigger t_test on a
for delete
as
delete b from deleted a,b b where a.bid=b.bid
delete from a where bid in(2,3)
select * from b
bid
-----------
1
(1 行受影响)