Posted by Shwetabh on 02/16/06 10:53

Erland Sommarskog wrote:
> 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

Well, apparently, since the dataabse will be used for Label printing,
the DBA has to
change the schema by adding new fields according to the requirements.
Do you suggest instead of normalising the database I should create a
single table
which holds all the fields which will be used for label? Or is thr some
better way out.
Now, since I am converting legacy database, it should be possible to
add data to the table through a single query which I cannot really
foresee happening in a normalised database.
What do u suggest?

[Back to original message]