SQL server 快速查找所有存储过程是否存在指定字符串

注意：
1、querystring 为所要查找的字符串，
2、查找范围为当前数据库

select name
from sysobjects o, syscomments s
where o.id = s.id
and text like '%querystring%'
and o.xtype = 'P' ORDER BY name


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