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 |
|
usafelix
Posting Yak Master
165 Posts |
 Posted - 2014-09-15 : 04:47:52
|
| Anyone can give a sql query statement for find a value in all tables ?if the data is 10G than how long the need searching time ? |
|
|
Arun Babu N
Starting Member
26 Posts |
Posted - 2014-09-15 : 04:52:53
|
| i didnt understand "value" .?what value in all tablesArun Babu N |
 |
|
|
Muj9
Yak Posting Veteran
75 Posts |
Posted - 2014-09-15 : 05:36:33
|
| i dont know if you can find the value but you can look in select * from INFORMATION_SCHEMA |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2014-09-15 : 07:03:23
|
| Check this: [url]http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm[/url]Harsh Athalyehttp://www.letsgeek.net/ |
|
|
|
usafelix
Posting Yak Master
165 Posts |
Posted - 2014-09-16 : 00:47:59
|
| About of "Value" is mean of data any text. for example I want to search in all table in which record to find out have " Mr Wong " This name. Then will list which table their records contain this wording. Thanks |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2014-09-16 : 02:54:13
|
| usafelix,Please check the link I posted. It should help you.Harsh Athalyehttp://www.letsgeek.net/ |
|
|
|
usafelix
Posting Yak Master
165 Posts |
Posted - 2014-09-16 : 03:02:55
|
| Hi Harsh, I am try access this link but nothing to see on my request related information. |
|
|
|
|
|
|
find a value in all tables