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 1, 2012 11:03 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:36 PM
Points: 31,368, Visits: 15,835
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 1, 2012 12:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:26 AM
Points: 29, Visits: 94
CSV support in SSMS (saving result sets as...) is deliberately broken. Gee, I wonder why.
Post #1391662
Posted Sunday, December 2, 2012 1:02 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:36 PM
Points: 31,368, Visits: 15,835
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 2, 2012 2:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:26 AM
Points: 29, Visits: 94
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 2, 2012 2:55 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:36 PM
Points: 31,368, Visits: 15,835
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 2, 2012 6:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:26 AM
Points: 29, Visits: 94
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 3, 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 @ 7:27 AM
Points: 35,769, Visits: 32,437
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."

(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 3, 2012 8:22 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 2:47 PM
Points: 708, Visits: 1,789
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 3, 2012 10:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334, Visits: 3,069
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 3, 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 @ 7:27 AM
Points: 35,769, Visits: 32,437
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."

(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