Posted by Erland Sommarskog on 02/16/06 10:10

Shwetabh (shwetabhgoel@gmail.com) writes:
> I understand what you are saying. But consider this scenario:
> A user needs a few more fields in the database and adds them to a table
> kept for the purpose. Now how can _those_ fields be accessed without
> using select *?

Changing the schema in a database is usually not something you do out of a
whim, and normally by a DBA, and not just any user.

And if a new field is added - how can you know off-hand that it is of
interest to you?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]