|
Posted by Adrienne Boswell on 05/25/07 07:40
Gazing into my crystal ball I observed "Chet" <cfnews@REMOVEcharter.net>
writing in news:J7w5i.734$As5.669@newsfe12.lga:
>
> I "DO" use the SELECT * in one call, but I use every column in
> that. In a case like this, is it better to name all of the
> columns?
>
>
It is ALWAYS better to explicitly list all columns you will use, even if
you are going to use all columns.
This article <http://www.sql-server-performance.com/transact_sql.asp> might
be of interest to you.
--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share
Navigation:
[Reply to this message]
|