By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Hiding NULL

P: n/a
In SQL 2000 Query Analyzer, you can set up the text output pane to
leave null values blank.

That could give you this (assuming it's set to comma-delimited) --

CREATE TABLE #Test (A int, B int)
INSERT #Test SELECT 1,2
INSERT #Test SELECT NULL,4
INSERT #Test SELECT 5,NULL
INSERT #Test SELECT NULL,NULL
SELECT * FROM #Test

A,B
1,2
,4
5,
,

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?

Thanks,
Jim

Mar 29 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
(ji**********@countrywide.com) 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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 29 '06 #2

P: n/a
Thanks, Erland. I will visit MS and make that request.

Jim

Mar 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.