SQL SERVER 字符串转多列数据

###创建函数 zoe_split

SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO

CREATE   FUNCTION [dbo].[zoe_split]
    (
      @c VARCHAR(8000) ,
      @split VARCHAR(2)
    )
RETURNS @t TABLE ( col VARCHAR(MAX) )
AS
    BEGIN     
        WHILE ( CHARINDEX(@split, @c) <> 0 )
            BEGIN   
                INSERT  @t
                        ( col
                        )
                VALUES  ( SUBSTRING(@c, 1, CHARINDEX(@split, @c) - 1)
                        )   
                SET @c = STUFF(@c, 1, CHARINDEX(@split, @c), '')   
            END   
        INSERT  @t
                ( col )
        VALUES  ( @c )   
        RETURN   
    END

GO

###执行函数 zoe_split 返回结果

select col from [dbo].[qsf_split]('one/two/three','/')

结果为

	col
1	one
2	two
3	three