Feedback is Encouraged

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Feedback is Encouraged

12 posts, Page 1 of 2

1 2 »»

Feedback is Encouraged

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Saturday, December 01, 2012 11:03 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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

fname lname-1111520

Posted Saturday, December 01, 2012 12:51 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:49 AM
Points: 27, Visits: 50

CSV support in SSMS (saving result sets as...) is deliberately broken. Gee, I wonder why.

Post #1391662

Steve Jones - SSC Editor

Posted Sunday, December 02, 2012 1:02 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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

fname lname-1111520

Posted Sunday, December 02, 2012 2:04 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:49 AM
Points: 27, Visits: 50

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

Steve Jones - SSC Editor

Posted Sunday, December 02, 2012 2:55 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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

fname lname-1111520

Posted Sunday, December 02, 2012 6:56 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:49 AM
Points: 27, Visits: 50

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

Jeff Moden

Posted Monday, December 03, 2012 6:15 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:57 PM
Points: 32,906, Visits: 26,790

fname lname-1111520 (12/2/2012)

+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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1391899

chrisn-585491

Posted Monday, December 03, 2012 8:22 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 479, Visits: 1,263

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... Sad