Answers for "sql find text in stored procedure"

SQL
3

search text in all sql server stored procedure

SELECT OBJECT_NAME(object_id)
    FROM sys.sql_modules
    WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
    AND definition LIKE '%Foo%'
Posted by: Guest on June-29-2020
3

find string in stored procedure sql server

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%strHell%'
Posted by: Guest on July-05-2020
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 "sql find text in stored procedure"

Code answers related to "SQL"

Browse Popular Code Answers by Language