[LzmTW].[String].[FindAll]

水如烟

于 2008-01-11 20:58:00 发布

阅读量1.1k

点赞数

分类专栏： VB.NET应用点滴文章标签： string table search insert function go

本文链接：https://blog.csdn.net/lzmtw/article/details/2038120

版权

VB.NET应用点滴专栏收录该内容

120 篇文章 0 订阅

订阅专栏

Author:水如烟

USE [ LzmTW ]
GO
-- ================================================================================
-- Author:LzmTW
-- Create date:20080111
-- Description:返回与条件相匹配的所有匹配字符串
-- ================================================================================
CREATE FUNCTION [ String ] . [ FindAll ]
(
      @Value nvarchar ( max )
    , @Search nvarchar ( max )
    , @IsVagueMode bit = 0
)
RETURNS
@Table TABLE
(
     [ Catch ] nvarchar ( max )
)
AS
BEGIN

     INSERT INTO @Table
     SELECT [ Catch ]
     FROM [ String ] . [ IndexArray ] (
          @Value
        , @Search
        , @IsVagueMode )

     RETURN
END