计算字符串由几个单词组成

字符串由几个单词组成，一般情况之下以空格分隔来计算即可。

实现方法，参考下面自定义函数：

 

 

set ansi_nulls on
go
set quoted_identifier on
go
-- =============================================
-- author:      insus.net
-- create date: 2019-05-13
-- update date: 2019-05-13
-- description: 计算字符串由几个单词组成
-- =============================================
create function [dbo].[svf_wordcount] 
( 
    @inputstring nvarchar(max)
) 
returns int
as
begin
    declare @index int = 1
    declare @currentchar char(1)
    declare @previouschar char(1)
    declare @wordcount int = 0

    while @index <= len(@inputstring)
    begin
        set @currentchar = substring(@inputstring, @index, 1)
        set @previouschar = substring(@inputstring, @index - 1, 1)
            
        if @previouschar = ' ' and @currentchar != ' '                
            set @wordcount = @wordcount + 1

        set @index = @index + 1
    end
    return @wordcount
end
go

 

举例演示：