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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-06-02 : 03:55:28
|
| I have more than 60 tables all tables have date, I want to find data from tbalesfor example communityorgnigation it is the data of the orgnigation tablehow can i serch for that date from all tables insted of checking each any every tableis there any possible way for serching |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-06-02 : 04:15:08
|
| You'll have to write a script to do it.Do you want to just search columns wit that name or any character columns?You could also bcp all data out from the database and search the file.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-06-02 : 04:21:36
|
| could u pls give example to write the script |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-06-02 : 04:25:20
|
| Maybe if you answer the question as to what you are looking for.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-02 : 04:37:14
|
quote:
Originally posted by boreddy
I have more than 60 tables all tables have date, I want to find data from tbalesfor example communityorgnigation it is the data of the orgnigation tablehow can i serch for that date from all tables insted of checking each any every tableis there any possible way for serching
DIdnt get what you're asking for. Can you provide some sample data to illustrate what you want? |
|
|
|
|
|
|
How to serch for data