sql server 搜存储过程关键字.

weixin_33781606

于 2014-04-22 18:21:00 发布

阅读量77

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/xmyy/articles/3681154.html

本文介绍了一种用于在SQL Server中通过关键字搜索存储过程和表值函数的方法。使用`syscomments`和`sysobjects`系统表来查找包含特定关键字的过程和函数，并按名称排序显示结果。

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

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

转载于:https://www.cnblogs.com/xmyy/articles/3681154.html