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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-16 : 08:18:45
|
| hemish writes "as i m developing search engine ,so i want different queries regarding search matching as early as possible" |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-16 : 09:18:44
|
| Sorry, I don't understand what you need help with, can you give me an example?Kristen |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-16 : 09:29:04
|
come on kristen....cant you see that he wants different queries regarding search matching as early as possible.  Go with the flow & have fun! Else fight the flow  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-16 : 09:59:54
|
| Ah, I see. We have to provide examples of different queries, for search matching, as quickly as we can.Its just like the Chinese Whispers we were playing with our 5 & 11 kids at Sunday lunch - except they were in French and hilarious!Kristen |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-16 : 10:08:59
|
heh....  but seriously:declare @col1InputValue varchar(100), @col2InputValue varchar(100), ...select @col1InputValue = 'someValue' -- @col2InputValue stays nullselec col2, col2, ...from table1where (col1 = @col1InputValue or @col1InputValue is null) and (col2 = @col2InputValue or @col2InputValue is null) and ...Go with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
search queries