Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

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

DZone's Guide to

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

·
Free Resource
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%'


Java Software
Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}