3
Add FOR CSV to facilitate CSV export
source link: https://feedback.azure.com/d365community/idea/6a0e286c-3f25-ec11-b6e6-000d3a4f0da0
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Posted inSQL
Microsoft
4 years ago
Add FOR CSV to facilitate CSV export
We have FOR XML and FOR JSON. But it is not uncommon that people want to produce CSV files. This can be done with BCP, but it is not straightforward not the least if you want to add headers. And if you only want fields to be quoted when needed, BCP is not really what you are looking for. SSIS is also an alternative, but SSIS does not always fit in.Thus, it would be handy if there was a an option like FOR CSV, with a syntax like:FOR CSV [, HEADERS] [,DELIMITER(',')] [, QUOTE('')]
Under Review
SuggestionsRecommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK