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 - 2001-01-21 : 12:08:35
|
Ethan Cottrell writes "This question comes in 2 parts.
Part 1:
I am building a search form that will query SQL Server 2000. The problem I am coming across is in the construction of the query that will be passed on to SQL. For starters the form has approximately 16 fields. All of which can be searched in the db and, only 4 require input resulting in an endless amount of possible queries to pass on to SQL. How can this query be acheived with out writing a SELECT statement for each possibility.
Part 2:
If this is possible to create in an ASP could it also be possible to create a stored procedure to perform the same operation?" |
|
|
|
|
|
Building Dynamic SQL Queries from ASP