Saving results with headers in Sql Server Management Studio

Question

I am using SQL Server Management Studio.

I wish to save the results of a query to an excel file.

I choose "save as" and then save to CSV file which I can open in excel. All good except I am missing column headers, any ideas how I get them exported?

Answer 1

Follow these steps:

Step 1: Go to Tools > Options 

Step 2: Select Query Results 

Step 3: Go to SQL Server 

Step 4: Choose Results to Text (or Grid if you want) & Include columns headers in the result set

Note: If you want to close and reopen SSMS after changing this option. Then, just go to the SQL Editor Toolbar and select save to file without restarting the SSMS.