Posted by David Portas on 10/23/05 20:07

"ric" <rtavert@yahoo.com> wrote in message
news:1130086527.567870.112960@z14g2000cwz.googlegroups.com...
> Hi,
>
> Is there a way to exclude fields in a query other than just including
> the ones you want. If there are 20 fields and you want to see all but
> 3, it would be a lot easier to exclude the 3.
>
> Thanks
>

No. It isn't difficult to list just the columns you want. In Query Analyzer
you can drag the column list from the Object Browser pane so no typing is
required.

Note that it is also good practice to avoid using SELECT * in production
code. Using * instead of listing just the required columns is not only
inefficient, it also impacts the reliability and maintainability of your
code.

--
David Portas
SQL Server MVP
--

[Back to original message]