Home » Topic » SQL Server Export CSV File

SQL Server Export CSV File

Lincoln Burrows ~ Modified: February 1st, 2016 ~ ~ 1 Minute Reading

Home › Forums › SQL Server Export CSV File

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • February 1, 2016 at 4:50 am #1069 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Which method will be best method to export a .csv file from SQL Server database?

    February 24, 2016 at 5:43 am #1163 Score: 0
    Stephen West
    Moderator
    4 pts

    There are several methods to export a CSV file from SQL Server database.
    1. Using SQL Server Management Studio
    >>Firstly using SELECT statement filter the data that you want to export.
    >>Now, Click on the top-left corner to select all rows
    >>After this, Right-Click to copy all the selected
    >>The paste the copied content on Microsoft Excel
    >>Save as CSV
    2. Using SQLCMD (Command Prompt).
    3. Using BCP you can export the CSV files.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.