SQL Server在存储过程中查找关键字

最新推荐文章于 2024-06-05 14:38:20 发布

转载最新推荐文章于 2024-06-05 14:38:20 发布 · 363 阅读

文章标签：

#数据库

本文介绍如何使用SQL查询存储过程及表函数中包含特定关键字的过程。通过编写存储过程 [_searchSP] 和 [_searchTableFunction] 来实现对存储过程和表函数的搜索功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在存储过程中查找(搜索，查询)关键字

SQL 查找存储过程中出现过的文字怎么查询呢?

select b.name
from 数据库名.dbo.syscomments a, 数据库名.dbo.sysobjects b
where a.id=b.id and b.xtype='p' and a.text like '%key words%'

order by name

create PROCEDURE [dbo].[_searchSP]
     @keywords nvarchar(100)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    select b.name
    from dbo.syscomments a, dbo.sysobjects b
    where a.id=b.id and b.xtype='p' and a.text like '%' + @keywords+ '%'
    order by name
END

create PROCEDURE [dbo].[_searchTableFunction]
     @keywords nvarchar(100)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    select b.name
    from dbo.syscomments a, dbo.sysobjects b
    where a.id=b.id and b.xtype='TF' and a.text like '%' + @keywords+ '%'
    order by name
END