存储过程————ＳＱＬ拆分字符

--declare @RoleList varchar(1000)
declare @RoleID int
--set @RoleList='23,22,35,40,'
declare @EndIndex int
declare @StartIndex int
set @StartIndex=1
if right(@RoleList,1)<>','
begin
 set @RoleList=@RoleList+','
end

while @StartIndex<=len(@RoleList)
begin
 set @EndIndex=charindex(',',@RoleList,@StartIndex);
 
 set @RoleID=cast(substring(@RoleList,@StartIndex,@EndIndex-@StartIndex) as int)
 
 set @StartIndex= @EndIndex+1;
 insert into #userRole(RoleID)
 values(@RoleID)
end