Tuesday, October 11, 2011

SQL Find Text

If you need to find text in a SQL stored procedure or function, the following query is helpful:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%[InsertTextHere]%'

No comments:

Post a Comment