SQL split表值 函数 调用 fnsplit('1,2,3',',')

 

ALTER FUNCTION [dbo].[fSplit](
@strSplitString varchar(8000),   --待分拆的字符串
@strSplitUnit varchar(10)     --数据分隔符
)RETURNS @result TABLE(col varchar(8000))
AS
BEGIN
  DECLARE @splitlen int
  SET @splitlen=LEN(@strSplitUnit)-1
  WHILE CHARINDEX(@strSplitUnit,@strSplitString)>0
  BEGIN
     INSERT @result VALUES(LEFT(@strSplitString,CHARINDEX(@strSplitUnit,@strSplitString)-1))
     SET @strSplitString=STUFF(@strSplitString,1,CHARINDEX(@strSplitUnit,@strSplitString)+@splitlen,'')
  END
  INSERT @result VALUES(@strSplitString)
  RETURN
END