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
Add a "text qualifier" in the export definition. The usual is double-quotes. Or use tabs instead of commas as the delimiter, if you can. .csv files work with either, in most cases. Can work with pipes (also called "vertical bar"; key above Enter on your keyboard, shift-backslash), too.
Semicolon after SQL Statements? Some database systems require a semicolon at the end of each SQL statement. Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.
Select your results by clicking in the top left corner, right click and select "Copy with Headers". Paste in excel. Done!
This one of the options that needs you to close that query window and open a new one before it takes effect.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With