[MSSQL]计算字符串分割数

 

-- =============================================   
-- Author:-- Create date:-- 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('