Advanced Search

Search stored procedures for string

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT    
  2.      ROUTINE_NAME,
  3.      ROUTINE_DEFINITION
  4. FROM    
  5.     INFORMATION_SCHEMA.ROUTINES
  6. WHERE    
  7.     ROUTINE_DEFINITION LIKE '%whatev%'
  8. ORDER BY
  9.     ROUTINE_NAME

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.