查数据库中所有包含了某个字符串的存储过程的SQL语句
查数据库中所有包含了某个字符串的存储过程的SQL语句，如图
select name
from sysobjects o, syscomments s
where o.id = s.id
and text like '%F_GetSomeCode%'
and o.xtype = 'P'
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%ZHMTL%'
AND ROUTINE_TYPE='PROCEDURE'