advanced code snippet search

Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

Find text in SP

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. -- Find text in a stored procedure
  2. SELECT	so.[name] AS 'storedProcedure'
  3. FROM	sysobjects so
  4. JOIN	syscomments sc
  5. ON		so.[id] = sc.[id]
  6. WHERE	so.[type] = 'P'
  7. AND		sc.[text] LIKE '%TEXT_YOU_WANT_TO_FIND%'

Report this snippet  

You need to login to post a comment.