Thursday, 22 August 2013

Sqlcmd export data to csv where fields have commas in the values

Sqlcmd export data to csv where fields have commas in the values

So I have an SqlCmd script set up to run a stored procedure and to output
the data into a CSV file, using the comma character as the field
separator.
How do I get the output to wrap fields with quotes so that any values that
have a comma in them don't mess up the CSV structure?

No comments:

Post a Comment