sqlserver split

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

 

 

ALTER     function [dbo].[f_split](@SourceSql varchar(8000),@StrSeprate varchar(10))
returns @temp table(id int identity(1,1),item varchar(100))
as
begin
    declare @i int,@str varchar(8000)
    set @str=rtrim(ltrim(@SourceSql))
    set @i=charindex(@StrSeprate,@str)
    while @i>=1
    begin
        insert @temp values(left(@str,@i-1))
        set @str=substring(@str,@i+1,len(@str)-@i)
        set @i=charindex(@StrSeprate,@str)
    end
    if @SourceSql<>'/'
       insert @temp values(rtrim(ltrim(@str)))
    return
end