[SQL必备存储过程] SQL SERVER 中全局搜索存储过程
这个存储过程,可以在当前数据库中按关键字查找所有存储过程,非常实用,DBA必备工具:
CREATE PROCEDURE [dbo].[SP]
@keywords nvarchar(100)= 'p_Comm_Area_GetList'
AS
BEGIN
SET NOCOUNT ON;
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%' + @keywords+ '%'
AND ROUTINE_TYPE='PROCEDURE'
END
用法:
exec sp 'keywords'