Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Feedback is Encouraged Expand / Collapse
Author
Message
Posted Saturday, December 01, 2012 11:03 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item Feedback is Encouraged






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1391654
Posted Saturday, December 01, 2012 12:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:45 AM
Points: 28, Visits: 73
CSV support in SSMS (saving result sets as...) is deliberately broken. Gee, I wonder why.
Post #1391662
Posted Sunday, December 02, 2012 1:02 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
What's broken? It seems to work for me.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1391744
Posted Sunday, December 02, 2012 2:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:45 AM
Points: 28, Visits: 73
SSMS 2012, results to grid, with the option to quote values containing the column delimiter. Why one wouldn't want to do that, among other things, is beyond me:

select
','
,'"'
,'
'
,',"
'

Surely, this is by no means an important feature (although quick and useful), but correct CSV output is so dirt simple to implement (case when value like '%[,"
]%' then '"' + replace(value,'"','""') + '"' else value end), it is very irritating that SSMS even has the option to save as (broken) CSV.

If enough folks ask for it...
Are there any other areas where SQL fails with CSV format? Bulk import?

Post #1391745
Posted Sunday, December 02, 2012 2:55 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Interesting. Didn't know that was broken. I'm sure this isn't on purpose. Have you reported this on Connect?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1391748
Posted Sunday, December 02, 2012 6:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:45 AM
Points: 28, Visits: 73
I have not reported it. From briefly perusing the several thousand results on Connect for SQL Server and "csv", the standard cop-out for this issue seems to be "use SSIS import/export tools."

The fact that there is an option in SSMS to "quote strings containing list separators when saving .csv results" says everything.
"Interoperability with non-MS tools? We sure won't make it easy!"

Here is an amusing post on Connect regarding BCP: http://connect.microsoft.com/SQLServer/feedback/details/127032/bcp-utility-should-support-rfc-4180-csv-files
Post #1391759
Posted Monday, December 03, 2012 6:15 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:00 PM
Points: 35,967, Visits: 30,258
fname lname-1111520 (12/2/2012)
I have not reported it. From briefly perusing the several thousand results on Connect for SQL Server and "csv", the standard cop-out for this issue seems to be "use SSIS import/export tools."

The fact that there is an option in SSMS to "quote strings containing list separators when saving .csv results" says everything.
"Interoperability with non-MS tools? We sure won't make it easy!"

Here is an amusing post on Connect regarding BCP: http://connect.microsoft.com/SQLServer/feedback/details/127032/bcp-utility-should-support-rfc-4180-csv-files


+1000
Ah... a kindred spirit!

I agree... why bother with feedback if the answer to many of the things you'd like to see is a referral to a tool that you don't want to use or can't use because of some restriction within the company? And, it IS a standard answer. SSIS doesn't always represent the needs of someone doing even simple ETL/File Import/Export of data stored in SQL Tables.

The other dangerous thing is that if they ever do an improvement based on feedback, they might deprecate something useful in the process. For example, I'm still scared to death that they'll deprecate xp_CmdShell in favor of the overcomplications of PowerShell. Don't get me wrong... PowerShell is a great tool for certain things. I just don't need it for simple file handling. I've still got lots of ETL code out there that keeps chugging away even though things like DTS went the wayside for SSIS, etc, ad infinitum.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1391899
Posted Monday, December 03, 2012 8:22 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 04, 2014 8:42 AM
Points: 598, Visits: 1,504
After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users...
Post #1391972
Posted Monday, December 03, 2012 10:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 06, 2014 1:05 PM
Points: 1,334, Visits: 3,068
chrisn-585491 (12/3/2012)
After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users...


Microsoft not listening to its users, now there is a novel concept.


"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1392055
Posted Monday, December 03, 2012 4:37 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:00 PM
Points: 35,967, Visits: 30,258
chrisn-585491 (12/3/2012)
After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users...


"Love the "ribbon"... or else!"


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1392182
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse