SQL split 分割字符串
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