Friday, June 29, 2012

Save SQL Query Results With Column Names

Save SQL Query Results With Column Names

 

It can be done by going to Tools - Options - Query Results - Sql Server - Results to Grid - Include column headers when copying or saving results. 



Click on Options....
 


 Click on Ok...





 Run your query and then Right click on Result -> then click on “Save Result As…”



 

Now, you can save the output in an excel file with Column name.

1 comments:

Aryan Arps said...

Thanks for providing such nice information to us. It provides such amazing information on care/as well Health/. The post is really helpful and very much thanks to you. The information can be really helpful on health, care as well as on examhelp/ tips. The post is really helpful.