What is wrong with using SELECT * FROM sometable | ansaurus

tags:

sql
tsql

views:

415

answers:

0

Q:

What is wrong with using SELECT * FROM sometable

Possible Duplicate:
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.

I have read the using "SELECT * FROM sometable" is bad practice, esp. if the query is being sent over a network.

Specifically what is wrong with it?

related questions

Backup SQL Schema Only?

Sql to query a dbs scheme

Timer-based event triggers

Sql query, count and group by

Paging SQL Server 2005 Results

SQL 2005 For XML Explicit - Need help formatting

How do I use T-SQL Group By

What all do I need to escape when sending a (My)SQL query?

Split String in SQL

Datatable vs Dataset

ASP.NET MVC "CRUD" Database Sample

Convert HashBytes to VarChar

Best Book for a new Database Developer

What is the best way to avoid SQL injection attacks?

What language do you use for Postgresql triggers and stored procedures?

What is the best way to handle multiple permission types?

How do I index a database field

Swap unique indexed column values in database.

cx_Oracle - what is the best way to iterate over a result set?

cx_Oracle - How do I access Oracle from Python?

Is there a version control system for database structure changes?

How to export data from SQL Server 2005 to MySQL

ASP.NET Site Maps

Decoding T-SQL CAST in C#/VB.net

Flat File Databases in PHP