SQL中自己创建函数 分割字符串(3)
来源:ddvip.com 时间:2008-11-20 16:13:00
select @location = charindex(@splitstr,@str,@start)
select @next = @next + 1
select @int_return = @next
end
return @int_return
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- getstrofindex 输入一个未分割的字符串,舒服分割符号,舒服要取得的字符位置
-- 返回 制定位置的字符串
CREATE function getstrofindex (@str varchar(8000),@splitstr varchar(4),@index int=0)
returns varchar(8000)
as
begin
declare @str_return varchar(8000)
declare @start int
declare @next int
declare @location int
select @start =1
select @next = 1 --如果习惯从0开始则select @next =0
select @location = charindex(@splitstr,@str,@start)
while (@location <>0 and @index > @next )
begin
select @start = @location +1
select @location = charindex(@splitstr,@str,@start)
select @next =@next +1
end
if @location =0 select @location =len(@str)+1 --如果是因为没有逗号退出,则认为逗号在字符串后
select @str_return = substring(@str,@start,@location -@start) --@start肯定是逗号之后的位置或者就是初始值1
if (@index <> @next ) select @str_return = '' --如果二者不相等,则是因为逗号太少,或者@index小于@next的初始值1。
return @str_return
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
淘宝搜索框研究报告
![](https://img.aspxhome.com/file/UploadPic/20107/27/2010727125528102s.png)
sql基本查询语句介绍
ASP脚本变量、函数、过程和条件语句
![](https://img.aspxhome.com/file/UploadPic/200812/2008121313306289.gif)
利用css的clear属性搞定广告文字环绕效果
正确理解SQL Server四类数据仓库建模方法
[翻译]JavaScript中对象的层次与继承
![](https://img.aspxhome.com/file/UploadPic/200812/31/cc-2-73s.png)
给网页添加打印功能按钮
![](https://img.aspxhome.com/file/UploadPic/200812/12/print-68s.jpg)
商品评论的设计
![](https://img.aspxhome.com/file/UploadPic/20101/11/1-70s.jpg)