|
|
Posted by Dan Guzman on 10/23/05 20:03
No, there is no Transact-SQL syntax for this. However, you can use Query
Analyzer to generate a SELECT statement for the desired view or table and
then remove the unneeded columns.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"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
>
Navigation:
[Reply to this message]
|