SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%文本%‘ AND ROUTINE_TYPE=‘PROCEDURE‘
查找含有某文本的存储过程
原文：http://www.cnblogs.com/mahatmasmile/p/6142207.html
