SQL SELECT *

It's a good idea as well as better coding practice to avoid using SELECT * in your SQL statements as it is inefficient. Listing all the fields expressly will improve the retrieval speed.

Why pull all the fields and their data when perhaps you only need 2 or 3 fields. By only selecting the fields we need you reduce the amount of data pulled from the database and thus speed up our web application.

I find sometimes that if I don't name the fields that when I come to write out the recordset that I have to check and check against the database to make sure that I have the correct fields and spelt them properly.

Just one thing, I realise that on some of the tutorials on this site i use SELECT *, shame on me though I must rewrite them once I get the time.

Previous: Server.MapPath

Next: Connecting to a MSSQLServer database