Return to Snippet

Revision: 16144
at July 27, 2009 15:37 by charmcitycoder


Updated Code
SELECT    
     ROUTINE_NAME,
     ROUTINE_DEFINITION
FROM    
    INFORMATION_SCHEMA.ROUTINES
WHERE    
    ROUTINE_DEFINITION LIKE '%whatev%'
ORDER BY
    ROUTINE_NAME

Revision: 16143
at July 27, 2009 15:37 by charmcitycoder


Initial Code
SELECT    
     ROUTINE_NAME,
     ROUTINE_DEFINITION
FROM    
    INFORMATION_SCHEMA.ROUTINES
WHERE    
    ROUTINE_DEFINITION LIKE �%whatev%�
ORDER BY
    ROUTINE_NAME

Initial URL
http://snippets.dzone.com/posts/show/3905

Initial Description


Initial Title
Search stored procedures for string

Initial Tags
sql, search

Initial Language
SQL