分割字符函数

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go

--分割字符函数 ALTER Function [dbo].[f_Split](@Sql varchar(2000),@Splits varchar(10)) returns @temp Table (tempColumn varchar(800)) 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 [f_Split]('1,2,3',',')