求一int型id是否在查询出来的一ID字符串中SQL? select ID,name FROM A WHERE a.ID IN ( SELECT b.settings FROM b WHERE b.id = 5 )b表settings字段内容"1,2,3,4,5"判断a表ID是否In 其中。运行报错:Operand type clash: text is incompatible with int有没有好的办法解决?谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 declare @s varchar(500)set @s = SELECT b.settings FROM b WHERE b.id = 5select ID,name FROM A WHERE charindex(a.ID, @s) > 0 select * from Awhere charindex(','+rtrim(a.id)+',',(select b.settings from b where b.id=5))>0 试试select ID,name FROM A WHERE exists (SELECT 1 FROM bWHERE b.id = 5and ','+b.settings+',' like '%,'+a.ID+',%' ) 求一条查询语句 紧急!!!手误执行了DROP Table。表中有500万的数据怎么恢复??? 求解 用like怎样连接两个表? "29-七月-2004 05:49:23 PM"形式的字符串如何转化为日期类型? 怎样实现查询出每天的在库量的问题?? 兄弟们来看看:ADO执行SQL语句,如果同时执行几条语句 关于重复的问题 请问要如何实现数据库表中字符串的替换? java连接SQLSERVER 2005时出错 请问如何简化下面的触发器? MSSQL 联接问题
set @s = SELECT b.settings FROM b WHERE b.id = 5
select ID,name
FROM A
WHERE charindex(a.ID, @s) > 0
where charindex(','+rtrim(a.id)+',',(select b.settings from b where b.id=5))>0
FROM A
WHERE exists (
SELECT 1 FROM b
WHERE b.id = 5
and ','+b.settings+',' like '%,'+a.ID+',%'
)