Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lovinguy
Starting Member
12 Posts |
 Posted - 2009-06-26 : 14:47:17
|
| HI!I would like to know that if there is any query to find a particular value in a database.For example i would like to find value "Mr.RAMESH",which tables & columns are having this value.Thanks in advance to Vaisakh and all members. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-26 : 14:49:56
|
| see belowhttp://vyaskn.tripod.com/search_all_columns_in_all_tables.htm |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-26 : 16:39:27
|
You can download the SSMSToolsPack fromhttp://www.ssmstoolspack.com/It is free and it is very good.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
cmdcenter
Starting Member
15 Posts |
Posted - 2009-06-27 : 03:27:55
|
This may not be relevant to your question, but if ever you wanted to search in stored procedures' text, you can use the following query:SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%keyword%' AND ROUTINE_TYPE = 'PROCEDURE' |
|
|
|
|
|
|
FINDING VALUE IN A DATABASE