sql server中自定义一个简单的 split 函数

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

create Function [dbo].[Split](@Sql varchar(8000),@Splits varchar(10))
returns @temp Table (a varchar(1000))
As
Begin
Declare @i Int
Set @Sql=replace(@Sql,' ','')
Set @Sql = RTrim(LTrim(@Sql))
Set @i = CharIndex(@Splits,@Sql)
While @i >= 1
Begin
 Insert @temp Values(RTrim(LTrim(Left(@Sql,@i-1))))
 Set @Sql = SubString(@Sql,@i+1,Len(@Sql)-@i)
 Set @i = CharIndex(@Splits,@Sql)
End

If @Sql <> ''
Insert @temp Values (@Sql)
Return
End