declare @finterids as varchar(100)
set @finterids='1,2,3'
select * from tblA where charindex(','+convert(varchar(10),finterid)+',',','+ @finterids+',')>0
set @finterids='1,2,3'
select * from tblA where charindex(','+convert(varchar(10),finterid)+',',','+ @finterids+',')>0
set @finterids='1,2,3'
select * from tblA where finterid in ( @finterids )改为declare @finterids as varchar(100)
set @finterids='1,2,3'
select * from tblA where charindex(cast(finterid as varchar),@finterids)>0
set @finterids='1,2,3'
select * from tblA where convert(varchar(10),finterid) in ( @finterids )
为什么定义一个字符窜变量呢
不是自己找麻烦了 ...