-- =============================================
-- 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('
[MSSQL]计算字符串分割数
最新推荐文章于 2020-07-27 09:08:27 发布