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