SQL Server Export CSV File
Lincoln Burrows ~
Modified: February 1st, 2016 ~ ~ 1 Minute Reading
- This topic has 1 reply, 2 voices, and was last updated 8 years, 2 months ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
-
Posts
-
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.
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.