一条简单的查询就这么难

[jdzwhy]

declare　@strid　varchar(20)

set @strid='57,4,61'

selct * from temp where convert(varchar,id) in (57,4,61)--可以查到记录

selct * from temp where convert(varchar,id) in (@strid)--通过参数传递为什么却查询不到记录

[快乐_石头]

selct * from temp where charindex(','+ltrim(id)+',',','+@strid+',')>0

[快乐_石头]

select * from temp where charindex(','+ltrim(id)+',',','+@strid+',')>0

[sdhdy]

declare @strid varchar(20) 
set @strid='57,4,61' 
exec ('select * from temp where convert(varchar,id) in ('+ @strid +')')