很简单
直接反向like即可
create Procedure demo(@id varchar(100))as
select name from table t where @id like ('%'+CONVERT(varchar(10),t.id)+'%')
exec '1,2,3,4'
很简单
直接反向like即可
create Procedure demo(@id varchar(100))as
select name from table t where @id like ('%'+CONVERT(varchar(10),t.id)+'%')
exec '1,2,3,4'