in括号中逗号的问题，比较简单

[xielk]

select * from sx where cast (id as char) in ('1','2') 返回结果

select * from sx where cast (id as char) in ( ' ''1'',''2'' ' )没有结果返回

select ' ''1'',''2''' ='1','2'

问怎样才能使
Set @s='1','2'
select * from sx where cast (id as char) in (@s)有结果返回
也就是说@s返回的值应该为'1','2'

[vivianfdlpw]

Set @s='''1'',''2'''
exec('select * from sx where cast (id as char) in ('+@s+')')

[vivianfdlpw]

--创建测试环境
create table sx
(
id char(1)
)
insert sx
select '1' union select '2'

--测试
declare @s varchar(10)
Set @s='''1'',''2'''
exec('select * from sx where cast (id as char) in ('+@s+')')

--删除测试环境
drop table sx

--结果
/*
id
----
1
2
*/

[lizhaogui]

select * from sx where cast (id as char) in ( ''1'',''2'' )

[pearl321]

select * from sx where cast (id as char) in (char(39)+'1'+char(39)+char(44)+char(39)+'2'+char(39))

[wgsasd311]

select * from sx where cast (id as char) in ( ' ''1'',''2'' ' )没有结果返回
----------------IN后面会被认为是传递一个参数，此参数值为：‘1’，‘2’
如要达到你想要的结果即两个参数，需动态SQL语句：
declare @sql varchar(8000)
set @sql= 'select * from sx where cast (id as char) in ('+ ' ''1'',''2'' '+')'
exec(@sql)

[MorningTea]

in
一定要这样形式：
in ('1','2')
所以你最终的sql必须凑成如上的形式
用动态sql,遇到单引号，2个代表一个

[wangdehao]

一句话，在sqlserver中，2个'表示一个'

[xielk]

想问一个
Set @s='''1'',''2'''
exec('select * from sx where cast (id as char) in ('+@s+')')
如果是游标的引用应该怎么写
declare p_cursor cursor for exec 'select * from sx where cast (id as char) in ('+@s+')'
???

[vivianfdlpw]

declare @s varchar(10)
Set @s='''1'',''2'''
declare @sql nvarchar(100)
set @sql='declare p_cursor cursor for select * from sx where charindex(cast (id as char),@s)>0'
exec sp_executesql @sql,N'@s varchar(10)',@s

open p_cursor

[zlp321002]

--try
select * from 表 where charindex(','1','2',',','+字段+',')>0

[zlp321002]

--测试环境
declare @t table( a varchar(20))
insert into @t select '''1'''
insert into @t select '''2'''
insert into @t select '''4'''
insert into @t select '''3'''
--查询语句
select * from @t where charindex(','+a+',',',''1'',''2'',')>0
--结果
a
--------------------
'1'
'2'