如果business_code是单条记录。。
select price from serivce_id where in(select service_id from business where business_code = @business_code)如果business_code是多条记录。。
select price from serivce_id where in(select service_id from business where business_code in @business_code)
应该这样写吗?
->NO
where in --> where exists
select price from serivce_id where in(select service_id from business where business_code = @business_code)如果business_code是多条记录。。
select price from serivce_id where in(select service_id from business where business_code in @business_code)
应该这样写吗?
->NO
where in --> where exists
解决方案 »
- 如何连接医院的HIS接口呀?
- SQL SERVER中返回指定日期是一个星期中的第几天的函数是什么?
- java.sql.SQLException: 第 1 行: 't_update' 附近有语法错误。
- 今天唯有的10分送上 触发器问题
- for xml auto问题,想把查询结果保存在变量@res 中
- 请教:MS SERVER 2008有什么好的性能监控工具或者方法?
- SQL2000提示说数据溢出了,谁能告诉我是怎么回事好吗?
- sqlserver 2005下建立的数据库库文件如何附加到SQLSERVER2000中?
- ID值可以人工修改吗?
- delphi换成EXCEL查询不到数据
- 请教!
- 用查询分析器执行sql语句时,出错
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)
select price from serivce_id where in(select service_id from business where business_code in @business_code)
应该这样写吗?不应该,应该这样写:
select price from serivce_id where in(select service_id from business where @business_code like '%'+business_code+'%')
或:
select price from serivce_id where in(select service_id from business where charindex(@business_code,business_code)>0)