SQLServer自定義函數——fnSplit

CREATE Function Split(@Sql varchar(8000),@Splits varchar(100))

returns @temp Table (tempColumn varchar(100))

As

Begin

 Declare @i Int

 Set @Sql = RTrim(LTrim(@Sql))

 Set @i = CharIndex(@Splits,@Sql)

 While @i >= 1

  Begin

  Insert @temp Values(Left(@Sql,@i-1))

  Set @Sql = SubString(@Sql,@i+len(@Splits),Len(@Sql)[email protected])

  Set @i = CharIndex(@Splits,@Sql)

  End

 If @Sql <> ''

 Insert @temp Values (@Sql)

 Return

End