set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''

Question

select * from xc.services where service_id in (select service_id from xc.business where business_code in ('+@business_code+'))返回记录为空啊

Answer 1

set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''
exec('
select * from xc.services where service_id in (select service_id from xc.business where business_code in ('+@business_code+'))'
)

Answer 2

set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''
select * from xc.services where service_id in 
(select service_id from xc.business 
where charindex(business_code,@business_code)>0)