如何在SQL Server中搜尋到一個帶有某關鍵字的預存程序?

反向工程中, 這一招很實用. 如果是研發人員, 就直接去原始碼控制工具中去搜尋了.

 

經過測試, 下面的任何一條查詢都可以滿足題目的需求.

 

SELECT Name     FROM sys.procedures         WHERE OBJECT_DEFINITION(object_id) LIKE '%foobar%' 

 

SELECT OBJECT_NAME(object_id)     FROM sys.sql_modules         WHERE Definition LIKE '%foobar%'             AND OBJECTPROPERTY(object_id, 'IsProcedure') = 1 

 

SELECT ROUTINE_NAME, ROUTINE_DEFINITION     FROM INFORMATION_SCHEMA.ROUTINES         WHERE ROUTINE_DEFINITION LIKE '%foobar%'             AND ROUTINE_TYPE='PROCEDURE'

 

資料來源:

How do I find a stored procedure containing <text>?

http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html