advanced code snippet search

Posted By

wilson0825 on 10/20/11


Tagged

search sp


Versions (?)

Search text and location stored procedure

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
  2.     FROM INFORMATION_SCHEMA.ROUTINES 
  3.     WHERE ROUTINE_DEFINITION LIKE '%ezpass%' 
  4.     AND ROUTINE_TYPE='PROCEDURE'

Report this snippet  

You need to login to post a comment.