How to export data as CSV format from SQL Server using sqlcmd?

by

You can run something like this:

sqlcmd -S MyServer -d myDB -E -Q "select col1, col2, col3 from SomeTable" 
       -o "MyData.csv" -h-1 -s"," -w 700
  • -h-1 removes column name headers from the result
  • -s"," sets the column seperator to ,
  • -w 700 sets the row width to 700 chars (this will need to be as wide as the longest row or it will wrap to the next line)

More Related Contents:

  1. Turning a Comma Separated string into individual rows
  2. How to split a comma-separated value to columns
  3. Import Multiple CSV Files to SQL Server from a Folder
  4. Bulk Insert Partially Quoted CSV File in SQL Server
  5. SQL Server Bulk insert of CSV file with inconsistent quotes
  6. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
  7. SQL Server BCP export corrupted file?
  8. How can I import an Excel file into SQL Server? [closed]
  9. SQL Server – join rows into comma separated list
  10. How to get the last row from a table in SQL Server?
  11. When should I use semicolons in SQL Server?
  12. How to get Time from DateTime format in SQL?
  13. Natural (human alpha-numeric) sort in Microsoft SQL 2005
  14. Select values from XML field in SQL Server 2008
  15. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  16. How do I exclude Weekend days in a SQL Server query?
  17. Best data store for billions of rows
  18. How do I list all tables in all databases in SQL Server in a single result set?
  19. How do I copy SQL Azure database to my local development server?
  20. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  21. SQL Server 2008 Vertical data to Horizontal
  22. Joining multiple tables returns NULL value
  23. Which join syntax is better?
  24. How to maintain the order of insertion in SQL Server
  25. Change type of a column with numbers from varchar to int
  26. Get row where datetime column = today
  27. Full text catalog/index search for %book%
  28. Why insert-select to variable table from XML variable so slow?
  29. Slow query with cfqueryparam searching on indexed column containing hashes
  30. How to avoid SSIS FTP task from failing when there are no files to download?

Leave a Comment