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 |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2006-05-11 : 03:25:57
|
| DearI have two different queires for searching particular text.I have nearly 7 to 8 table in my database. all tables are related to each other by using foreign key.now i want to a query which search particular text in all fields of all tables.what would be qury for this.second question is nearly same but in this all tables are not related to each other. all tables are independent.what would be query.Waiting for replyBest regards, |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-11 : 03:31:28
|
Post some of the table structure, some sample data and the expected result that you want
KH |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-05-11 : 03:31:43
|
| for the first query use Join to link all the tables.. and for the second query use union all to combine all the tables for searching.. Pls post same sample data and expected results so that you get what you wantIf Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-11 : 04:03:10
|
| http://vyaskn.tripod.com/search_all_columns_in_all_tables.htmMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
I have two queries for searching text