Re: Hiding NULL
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 29 Mar 2006 21:37:41 +0000 (UTC)
(jim_geissman@xxxxxxxxxxxxxxx) writes:
I can't figure out how to set up 2005 Management Studio the same way.
I can only manage to get outputs like this, with "NULL" instead of
empty fields --
A,B
1,2
NULL,4
5,NULL
NULL,NULL
How can I get rid of the NULLs?
All I can suggest is that you go to
http://lab.msdn.microsoft.com/ProductFeedback/ and submit a suggestion
that Microsoft restores this possibility in the next version of SQL
Server.
There are many features in QA that did not make it to Mgmt Studio. To be
fair, QA has some odd quirks, even if several of them are practical. For
instance, this one is good if you want to copy and paste into Excel. Then
again, in Mgmt Studio, it's easier to copy and paste from grid, as you
now can opt to include the headers. (Tools->Options->Query Results->Results
to Grid.)
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Hiding NULL
- From: jim_geissman
- Re: Hiding NULL
- References:
- Hiding NULL
- From: jim_geissman
- Hiding NULL
- Prev by Date: Re: Sql server report
- Next by Date: Re: speeding up inserts
- Previous by thread: Hiding NULL
- Next by thread: Re: Hiding NULL
- Index(es):
Relevant Pages
|
