Posted by Roy Harvey on 02/20/07 12:41

I agree with you up to a point, but there are pitfalls.

Don't forget that if the SELECT * is in a stored procedure or a view,
the * is resolved into the columns when the procedure is CREATEd or
ALTERed. If you do not remember to re-ALTER them after a change to
the underlying table they will not reflect the current table
structure.

Roy Harvey
Beacon Falls, CT

On Tue, 20 Feb 2007 02:44:58 GMT, Wes Groleau
<groleau+news@freeshell.org> wrote:

>Never say never.....
>
>One of my applications loads a huge amount of data from a text file,
>sifts through and discards much of it, and rearranges what's left.
>Finally, it is added to similar data from many other files.
>
>For that last step, SELECT * is the sensible way to go.
>If you really do want everything, why force yourself to
>have to edit the select if ever a column is added or deleted?

[Back to original message]