Search Particular Word Or Text From The Entire Stored Procedure In The Database
Join the DZone community and get the full member experience.Join For Free
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
Opinions expressed by DZone contributors are their own.