Export from SQL Server 2012 to .CSV through Management Studio
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?
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.
Right click on your database in management studio and choose Tasks -> Export Data...
Follow a wizard, and in destination part choose 'Flat File Destination'. Type your file name and choose your options.