sql 分离字符串 获得数组函数 包括字符串数组的排序

create function GetArrayTable(@SourceSql varchar(8000),@StrSeprate varchar(10))
returns @temp table(element nvarchar(4000),orderNum int)
as
begin
    declare @i int
    declare @length int
   
    set @length = 0
    set @SourceSql=rtrim(ltrim(@SourceSql))
    set @i=charindex(@StrSeprate,@SourceSql)

    while @i>=1
    begin
        set @length = @length + 1
        insert @temp(element,orderNum) values(left(@SourceSql,@i-1),@length)
        set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i)
        set @i=charindex(@StrSeprate,@SourceSql)
    end

    if @SourceSql<>''
    begin
        set @length = @length + 1
        insert @temp values(@SourceSql,@length)
    end
    return
end