SQL SERVER中查找某关键词位于哪些存储过程或函数

 

USE [MYDB] go

 SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_type='PROCEDURE' AND routine_definition LIKE '%关键词 %'