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

  • 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=""><strong>Java Software</strong></a>