■/*******************...... /******************************************* ** File: fnSplit.sql ** Name: fnSplit ** Description: Split the string. 分割字符串 ** Return values: @temp ** Parameters: @sql,@splits ** Author: 何毅翔(MyGodness) ** Date: 2005-1-11 ** Use Method: select * from dbo.split('1,2,3,4',',') **********************************************/ 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)-@i) Set @i = CharIndex(@Splits,@Sql) End If @Sql <> '' Insert @temp Values (@Sql) Return End |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 19:22 , Processed in 0.220434 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.