advanced code snippet search

Posted By

dmilligan on 12/27/12


Tagged

sql stored procedure


Versions (?)

Search Stored Prcedures Code

 / Published in: SQL
 

Search the source code of all stored procedures.

Expand | Embed | Plain Text 
  1. SELECT TOP 1000 
  2. 	[ROUTINE_NAME]
  3. 	,[ROUTINE_DEFINITION]
  4. 	,ROUTINE_TYPE
  5. FROM ebiz.[INFORMATION_SCHEMA].[ROUTINES]
  6. WHERE ROUTINE_TYPE IN ('PROCEDURE', 'FUNCTION') 
  7. 	AND [ROUTINE_DEFINITION] LIKE '%something to find%'

Report this snippet  

You need to login to post a comment.