|M| 如果根据一个数组删除数据库记录 强
如A表有字段DeleteID
A
DeleteID
2,4,5,6
B
ID Name
1 Age
2 Apple
3 Orange
4 Egg
5 Banana
6 Tomato
写出SQL语句根据A表中的DeleteID里面的ID号删除B表的相应记录
谢谢
[解决办法]
delete from B where charindex(DeleteID,(select DeleteID from A) )> 0
[解决办法]
create table A(DeleteID varchar(20))
insert A select '2,4,5,6 '
create table B(ID int,Name varchar(20))
insert B select 1, 'Age '
union all select 2, 'Apple '
union all select 3, 'Orange '
union all select 4, 'Egg '
union all select 5, 'Banana '
union all select 6, 'Tomato '
delete from B where charindex( ', '+rtrim(ID)+ ', ', ', '+(select DeleteID from A)+ ', ')> 0
select * from B
drop table A,B
[解决办法]
delete from b
from b inner join a on a.detailId=b.id