sql server常用自定义函数

1.字符串分隔函数

-----------字符串分隔函数-------------
CREATE Function [dbo].[Split]
(
  @Sql varchar(8000),
  @Splits varchar(10)
)
returns @temp Table (a 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+1,Len(@Sql)-@i)
    Set @i = CharIndex(@Splits,@Sql)
  End

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

select * from dbo.Split('abc,def,ghi,kly',',')

----------结果------------------------------

abc

def

ghi

kly