Answers for "how to find text in all stored procedures"

1

find stored procedure with text

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%Foo%' 
    AND ROUTINE_TYPE='PROCEDURE'
Posted by: Guest on June-16-2021

Code answers related to "how to find text in all stored procedures"

Browse Popular Code Answers by Language