Search code examples
sqlsql-serverbcpsqlcmdosql

BCP / sqlcmd / osql with encapsulated text fields?


Can any of these command line tools export to .csv like:

"int_field", "varchar_field", "another_int_field"
10, "some text", 10
5, "more text", 1

etc?

i don't want to use a view or stored procedure to hack the double quotes in :)


Solution

  • Looks like this confirms my suspicions that the answer is:

    No.

    Thanks for the alternative suggestions.