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-02-12 : 11:59:26
|
Louis writes "There is a question I have been pondering for quite some time. After consulting with many experts in the company, I still could not find the optimal answer to the question. So here I am posting this, hoping some guru will be able to answer it.
First off, I'm using WinNT 4.0 with Microsoft SQL Server 7.0.
I have an ASP that allows users to add or update fields inside multiple tables. The ASP takes the table name as a parameter, writes out all the column names, and asks the user for input. Currently it uses "SELECT * FROM tablename" to retrieve all the field names. However, when faced with a huge table, this process is extremely slow.
How could I setup my query so that I don't need to go through the entire table just to retrieve the field names? I know I could hardcode a page for each table, but with 15+ tables, it would be more efficient if I used one ASP for all the tables.. since their function is the same.
Thanks for all your help :)" |
|
|
|
|
|
Selecting zero rows from a table in an ASP?