实现MS SQL存储过程中传入的“，”分隔字符串的（in）操作

传入的@items值是(2,3,5,8,)这种类型

 

/*显示选中的商铺的资讯列表*/
CREATE procedure select_NewListByshopId
@flag int,
@keyword Varchar(50),
@sDate  DateTime,
@items  varchar(100)
as
declare @split varchar(1)
set @split=','
declare @T_Module table(m varchar(4000))
while charindex(rtrim(@split),@items) <>0
begin
set @items=ltrim(rtrim(@items))
if(substring(@items,1,1) <>@split)
  begin
  insert into @T_Module (m) values(substring(@items,1,charindex(@split,@items)-1))
  set @items =stuff(@items,1,charindex(@split,@items),'')
  end
else
  begin
  set @items=stuff(@items,1,1,'')
  end
end
if rtrim(@items) <>''
insert into @T_Module (m) values (@items)

select a.ID,a.sort,a.Title,a