sql server 分割字符串储存过程

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <zhushagnwei,,Name>
-- Create date: <2013-11-09,,>
-- Description:    <根据手机id得到所有手机安装应用,,>
-- =============================================
alter PROCEDURE pro_GetPhoneAppsByRadar
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    declare @appids nvarchar(2000);  --要分割的字符串（，）分割
    declare @queryString nvarchar(2000)
    declare @temp varchar(32)
    declare @pos int
    declare @len int
    set @queryString=@appids
    set @pos=Charindex(',',@queryString,0)
    
    while(@pos>0)  --循环
    begin
    set @temp=Substring(@queryString,0,@pos)
    set @len=len(@temp)
        
    print @temp;  --将分割出的变量输出
    
    set @queryString=Stuff(@queryString,1,@len+1,'')
    set @pos=Charindex(',',@queryString,0)
    
    end
    
END
GO