[MS SQL] 查詢StoredProcedure中的Key Word

查詢StoredProcedure中的Key Word 

SELECT 
name AS StoredProcedureName,
OBJECT_DEFINITION(OBJECT_ID(name)) AS ProcedureDefinition
FROM sys.procedures
WHERE 
upper(OBJECT_DEFINITION(OBJECT_ID(name))) LIKE '%KEY_WORD%'
ORDER BY name;

參考網址: 

By Hao★