DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Search Particular Word Or Text From The Entire Stored Procedure In The Database

12.19.2011
| 1853 views |
  • submit to reddit
        following code will find text "GetUsers" from the entire stored procedure in the database.
SELECT distinct(OBJECT_NAME(id)) FROM syscomments WHERE text like '%GetUsers%'

<a href="http://www.java-forums.org/java-software/"><strong>Java Software</strong></a>