Answers for "find text in stored procedure databse"

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 "find text in stored procedure databse"

Browse Popular Code Answers by Language