逗号分割字符串存储过程

Create proc BBB(@source nvarchar(2000) output,@returnSource nvarchar(200) output)
AS
BEGIN
 declare @index int;
 
 select @index = charindex(',',@source)
 IF @index > 0
 begin
  select @returnSource = substring(@source,0,@index)  
  select @source = SUBSTRING(@source,@index+1,len(@source)-@index)  
 end
 ELSE
 BEGIN
  set @returnSource=@source
  set @source=''
 END 
END

 

 

执行存储过程

  DECLARE @SOURCE nvarchar(2000)
  DECLARE @str nvarchar(200)
  SET @SOURCE ='1,2,3,4'
  WHILE @SOURCE IS NOT NULL AND @SOURCE <> ''
  BEGIN
   exec P_PopString @SOURCE output,@str output
   SELECT @SOURCE+'       '+@str
  END