Posted by Hugo Kornelis on 06/17/92 11:45

(excessive crossposting limited to two of the foour groups)

On Tue, 18 Apr 2006 17:57:02 +0200, Peter wrote:

>From this discussion I conclude:
(snip)
>Thanks to all, I know what is the impact of this choice.
>
>Unless someone has to add some new point in this discussion :-)

Hi Peter,

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.

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: select * in views
• Prev in forum: Re: How to Get the 2nd the 2nd Record AND DISPLAY IN SINGLE ROW ?
• Thread view: Re: select * in views

[Reply to this message]