SQL Queries:

Searching for a text in in a stored procedure:


SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM NFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%foobar%'  AND ROUTINE_TYPE='PROCEDURE'