Search stored procedures for string - SQL Snipplr Social Repository

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

Choose a language for easy browsing: