SQL-Server

Find particular word or text from the entire stored procedure

Sunasara Imdadhusen

Rate me:

Please Sign up or sign in to vote.

4.22/5 (9 votes)

22 May 2011CPOL 41.7K   7   7

SQL

SELECT distinct(OBJECT_NAME(id)) FROM syscomments WHERE text like '%GetEmployee%'

It will find text "GetEmployee" from the entire stored procedure in the database.

Thanks,
Imdadhusen

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Sunasara Imdadhusen

Technical Lead Infostretch Ahmedabad-Gujarat

 India

Aspiring for a challenging carrier wherein I can learn, grow, expand and share my existing knowledge in meaningful and coherent way.

sunaSaRa Imdadhusen

AWARDS:

1. 2^nd Best Mobile Article of January 2015
2. 3^rd Best Web Dev Article of May 2014
3. 2^nd Best Asp.Net article of MAY 2011
4. 1^st Best Asp.Net article of SEP 2010

Read More Articles...

Comments and Discussions

First Prev Next

My vote of 2 Member 793464812-Dec-12 3:00 Member 7934648 12-Dec-12 3:00  Good example to see the existence of table "syscomments" but it is not very useful as an example. Re: My vote of 2 Sunasara Imdadhusen22-Apr-14 4:04 Sunasara Imdadhusen 22-Apr-14 4:04  Thank you very much for your comment and feedback. My vote of 5 Savalia Manoj M7-Nov-12 1:09 Savalia Manoj M 7-Nov-12 1:09  Good one... Re: My vote of 5 Sunasara Imdadhusen22-Apr-14 4:04 Sunasara Imdadhusen 22-Apr-14 4:04  Thank you very much for your comment and feedback. My 5. I used this in the past. Costica U25-Apr-11 22:30 Costica U 25-Apr-11 22:30  My 5. I used this in the past. Re: This tip is good one however the alternate is much better. A... Gandalf_TheWhite29-Apr-11 1:11 Gandalf_TheWhite 29-Apr-11 1:11  This tip is good one however the alternate is much better. Anyways 5d. Re: My 5. I used this in the past. Sunasara Imdadhusen22-Apr-14 4:05 Sunasara Imdadhusen 22-Apr-14 4:05  Thank you very much for your appreciations

Last Visit: 31-Dec-99 18:00     Last Update: 23-Apr-24 23:31 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.