方法一
select name
from sysobjects o, syscomments s
where o.id = s.id
and text like '%test1%'
and o.xtype = 'P'
方法二
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%test1%'
AND ROUTINE_TYPE='PROCEDURE'
返回所有出现过该字符串的存储过程名: