CODEWITHSUNDEEP
sqlssmssql-server-2008-express
André Alçada Padez
André Alçada Padez

Reputation: 11628

SQL - "Save results as CSV" - use comma instead of Semi-Colon

Hey, i need to export a query result to a CSV, but i get a semi-colon as a delimiter.
I went to: 

Tools - Options - Query Results - SQL Server - Results to Text

and set 

Output format: Custom delimiter  
Custom delimiter: ,

and i still get the semicolon. when i return to the options, the original configuration is set.

I'm using MS SQL Management Studio 2008.

Thanx for the help

Upvotes: 27

Views: 31929

Answers (1)

Thomas Rushton
Thomas Rushton

Reputation: 5826

This one of the options that needs you to close that query window and open a new one before it takes effect.

Upvotes: 31

Related Questions