I agree with Joe... I would refrain from using a sweeping statement like that. And Stephen, what if I did need *all* the columns from a particular table? ;-)
On Apr 14, 9:15 pm, Joe Enos <[email protected]> wrote: > Of course, for all of the developers who have a data access layer that > converts table contents to objects, "select *" is just fine, since the > data layer probably requires this. So "NEVER" is a bit strong, don't > you think? > > On Apr 14, 8:06 am, "Stephen Russell" <[email protected]> wrote: > > > > > For all of you developers please NEVER select "*" > > > Try : > > Select <FieldList> from MyTable > > > The least # of Columns out of your data source will ALWAYS be faster. Isn't > > that what we strive for? > > > ………………………………………………………………… > > Stephen Russell – > > Senior Visual Studio Developer, DBA > > > Memphis, TN > > 901.246-0159 >
