-- =============================================
-- Author: <David Gong>
-- Create date: <2011-12-06>
-- Description: <计算字符串分割数>
-- =============================================
ALTER FUNCTION [dbo].[func_get_split_num](@str varchar(8000))
returns int
as
begin
declare @int_return int
declare @start int
declare @next int
declare @location int
select @str=','+@str+','
select @str=replace(@str,',,',',')
select @start=1
select @next=1
select @location=charindex(',',@str,@start)
while(@location<>0)
begin
select @start=@location+1
select @location=charindex(',',@str,@start)
select @next=@next+1
end
select @int_return=@next-2
return @int_return
end
扫一扫
评论
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
