Question: how to export data from sql server to csv file using query?
Answer: Open SQL Server Management Studio. Go to Tools > Options > Query Results > SQL Server > Results To Text. On the far right, there is a drop down box called Output Format. Choose Comma Delimited and click OK.