I am creating this blog mostly for me, so that I have references of things I use a lot and just a place to write down any random thoughts I want to. If you've stumbled across this and enjoy it, that's great. If not, that's just as well too.
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