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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How to find a value using a SP

Author  Topic 

Oliver wang
Yak Posting Veteran

50 Posts

Posted - 2012-02-20 : 03:41:34
Hi Everyone,

I have question regarding searching a value:
I have a database which contains hundreds of tables. I want to find out in which table and column I can find a specific cell value, such as "AABBCC". Is there any stored procedure which can achieve that? Thank you for your help in advance.

regards,

Oliver

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2012-02-20 : 03:45:47
Have a eye on this

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page

Oliver wang
Yak Posting Veteran

50 Posts

Posted - 2012-02-20 : 04:04:11
Wow~Senthil, you are awesome~Thank you very much for your sharing

regards,

Oliver
Go to Top of Page

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2012-02-20 : 04:06:54
You are welcome..

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page
   

- Advertisement -