Export from SQL Server 2012 to .CSV through Management Studio

sql sql-server csv sql-server-2012
Webbly Brown picture Webbly Brown · Jul 4, 2013 · Viewed 94.2k times · Source

I have a SQL Server 2012 database that I am trying to export to .CSV. My knowledge of SQL is very basic and my question is, I'm assuming it would be done in Management Studio, how do I do this?

Answer

Nick Howard picture Nick Howard · Jun 12, 2014

If it is the query results you want exported to csv, you can right click on the results grid and select "Save Results As", which will allow you to save as csv.

Related questions

How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More
Import CSV file into SQL Server

I am looking for help to import a .csv file into SQL Server using BULK INSERT and I have few basic questions. Issues: The CSV file data may have , (comma) in between (Ex: description), so how can I make import …

Read More
Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column

I'm trying to insert a large CSV file (several gigs) into SQL Server, but once I go through the Import Wizard and finally try to import the file I get the following error report: Executing (Error) Messages Error 0xc02020a1: …

Read More