22,210
社区成员
发帖
与我相关
我的任务
分享
select * from tb where ','+@s+',' LIKE '%,'+ltrim(id)+',%'
--法三
select * from tb where ','+ltrim(id)+',' like '%,'+@s+',%'
--法三
select * from tb where ','+ltrim(id)+',' like '%,'+@s+',%')>0
declare @s varchar(100)
set @s='1,2,3'
--法一:
select * from tb where charindex(','+ltrim(id)+',',','+@s+',')>0
--法二:
exec('select * from tb where id in ('+@s+')')