create table #t1 (a int,b int)
insert into #t1 values(1,1)
insert into #t1 values(2,1)
insert into #t1 values(3,1)
insert into #t1 values(4,1)
create table #t2 (a int,b int)
insert into #t2 values(1,1)
insert into #t2 values(2,1)
delete #t1 where exists(select 1 from #t2 y where a = #t1 .a and b=#t1.b)
select * from #t1
以下应该可以的:
create table #t1 (a int,b int)
insert into #t1 values(1,1)
insert into #t1 values(2,1)
insert into #t1 values(2,2)
insert into #t1 values(1,2)
insert into #t1 values(4,1)
create table #t2 (a int,b int)
insert into #t2 values(1,1)
insert into #t2 values(2,2)
select * from #t1
select * from #t2
select identity(int,1,1) as id,* into #t3 from #t1
delete from #t3 where id in
(
select id from #t3 y where exists(select 1 from #t2 where a = y.a and b=y.b)
)
create table #t1 (a int,b int)
insert into #t1 values(1,1)
insert into #t1 values(2,1)
insert into #t1 values(3,1)
insert into #t1 values(4,1)
create table #t2 (a int,b int)
insert into #t2 values(1,1)
insert into #t2 values(2,1)
delete #t1 where a in(select y.a from #t2 y) and b in(select y.b from #t2 y)
create table #t1 (a int,b int)
insert into #t1 values(1,1)
insert into #t1 values(2,1)
insert into #t1 values(3,1)
insert into #t1 values(4,1)
create table #t2 (a int,b int)
insert into #t2 values(1,1)
insert into #t2 values(2,1)
delete #t1 where exists(select 1 from #t2 y where a = y.a and b=y.b)
select * from #t1