Posted by Erland Sommarskog on 10/02/11 11:45

Hugo Kornelis (hugo@perFact.REMOVETHIS.info.INVALID) writes:
> The point I'm missing in your summary is the ease of impact analysis.
>
> If you use SELECT * anywhere (other than an EXISTS subquery), you lose
> the possibility to do an impact analysis of a proposed change by
> searching the source code (CREATE scripts) of your database.

A good point, but as Peter seems to using the views as a sort of
synonyms, I think he is covered on that point. That is, when you
work with his system, you need to know that the views mirror the
tables in some way.

But in the general case, you are perfectly right.



--
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

• Next in forum: Re: delete sql syntax for linked notes table
• Prev in forum: Re: select * in views
• Thread view: Re: select * in views

[Reply to this message]