Don't Use Select * in Database Queries

June 3, 2005

[From ASP101]

Something you see in a lot of database access code is a select statement that looks something like this:

SELECT * FROM TableName WHERE ... 

While there's technically nothing wrong with it, using the SELECT * syntax could be stealing away precious performance from your application, and even it it's not now, it might someday soon.

The article continues at http://www.asp101.com/tips/index.asp?id=125