在将 varchar 值 '1,2,3,4,5,6' 转换成数据类型 int 时失败。解决办法
declare @ids varchar(100)
set @ids='1,2,3,4,5,6'
select * from table1 where charindex(','+ltrim(id)+',',','+@ids+',') > 0
declare @ids varchar(100)
set @ids='1,2,3,4,5,6'
select * from table1 where charindex(','+ltrim(id)+',',','+@ids+',') > 0