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 |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2008-08-05 : 21:30:00
|
| It is possible SQL Server 2000 searching in all column? Let's say i've table as followCstomerTransID | CustNme | Adr1 | Adr 2 | Tel----------------------------------------------------1 | Jenna | Tokyo | 869 | 99802 | Adam | Quebec | 887 | 187-9803 | Linda | Beijing | 665 | 2865......1. I've thinking my front-end having 1 texbox and 1 submit button.2. User will key-in keyword in this textbox for searching3. The submit button will pressed, then result will be displayed after searching.4. This searching will seek in all column in my Cstomer table (except TransID)How my SQL looks like? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-05 : 22:32:36
|
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2008-08-06 : 03:01:11
|
| tq very much. it give me an idea |
|
|
|
|
|
|
SQL scripts - searching in all column