Export query result to .csv file in SQL Server 2008

Question

How can I export a query result to a .csv file in SQL Server 2008?

Answer 1

1. Open SQL Server Management Studio
2. Go to Tools > Options > Query Results > SQL Server > Results To Text
3. On the far right, there is a drop down box called Output Format
4. Choose Comma Delimited and click OK

Here's a full screen version of that image, below

This will show your query results as comma-delimited text.

To save the results of a query to a file: Ctrl + Shift + F