Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesIn 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
Post Follow-up to this messageThanks, Erland. I will visit MS and make that request. Jim
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread