开发者

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

开发者 https://www.devze.com 2023-02-03 17:59 出处:网络
Hey, i need to export a query result to a CSV, but i get a semi-colon as a delimiter. I went to: 开发者_开发百科

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


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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号