Error
  • JHTMLicon not supported. File not found.
  • JHTMLicon not supported. File not found.
  • JHTMLicon not supported. File not found.

distinctobject_nameid

Search particular word or text from the entire stored procedure in the Database
Monday, 19 December 2011 00:32
the-from-text-distinctobject_nameid-database select
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%'

Read more: http://feeds.dzone.com/~r/dzone/snippets/~3/oce8hWa5obQ/14225
 


Taxonomy by Zaragoza Online

Login Form



Scroll To Top