Author:水如烟
USE
[
LzmTW
]
GO
-- =======================================================================================
-- Author:LzmTW
-- Create date:20080111
-- Description:返回搜索字符串在被搜索字符串中的匹配数。
-- =======================================================================================
CREATE FUNCTION [ String ] . [ CountOf ]
(
@Value nvarchar ( max )
, @Search nvarchar ( max )
, @IsVagueMode bit = 0
)
RETURNS int
AS
BEGIN
DECLARE @Result int
SELECT @Result = COUNT ( * )
FROM [ String ] . [ IndexArray ] (
@Value
, @Search
, @IsVagueMode )
RETURN @Result
END
GO
-- =======================================================================================
-- Author:LzmTW
-- Create date:20080111
-- Description:返回搜索字符串在被搜索字符串中的匹配数。
-- =======================================================================================
CREATE FUNCTION [ String ] . [ CountOf ]
(
@Value nvarchar ( max )
, @Search nvarchar ( max )
, @IsVagueMode bit = 0
)
RETURNS int
AS
BEGIN
DECLARE @Result int
SELECT @Result = COUNT ( * )
FROM [ String ] . [ IndexArray ] (
@Value
, @Search
, @IsVagueMode )
RETURN @Result
END