34,576
社区成员
发帖
与我相关
我的任务
分享set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''
出错啊，business_code 没有值啊
...全文
请发表友善的回复…
发表回复
伊凡yifan 2003-09-29
- 打赏
- 举报
马可，四百分都归你了。
txlicenhe 2003-09-29
- 打赏
- 举报
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)
txlicenhe 2003-09-29
- 打赏
- 举报
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+'))'
)
exec('
select * from xc.services where service_id in (select service_id from xc.business where business_code in ('+@business_code+'))'
)
伊凡yifan 2003-09-29
- 打赏
- 举报
select * from xc.services where service_id in (select service_id from xc.business where business_code in ('+@business_code+'))
返回记录为空啊
返回记录为空啊
记一次clickhouse查询问题Double-distributed IN/JOIN subqueries is denied (distributed_product_mode = ‘deny‘)
