CREATE FUNCTION [dbo].[ufn_CountChar] ( @pInput VARCHAR(1000), @pSearchChar CHAR(1) ) RETURNS INT BEGIN DECLARE @vInputLength INT DECLARE @vIndex INT DECLARE @vCount INT SET @vCount = 0 SET @vIndex = 1 SET @vInputLength = LEN(@pInput) WHILE @vIndex <= @vInputLength BEGIN IF SUBSTRING(@pInput, @vIndex, 1) = @pSearchChar SET @vCount = @vCount + 1 SET @vIndex = @vIndex + 1 END RETURN @vCount END GO
ufn_CountChar
最新推荐文章于 2022-06-28 08:43:04 发布