Dave's Blog

Business Intelligence: Transforming data into decisions

January 2009 - Posts

Copy query results WITH column headers!

If you work a lot with SQL Server, like I do, the missing column headers when you copy query results from a query in the Management Studio is a major frustration.

A colleague pointed me to a nice option to keep those headers while copying your data Big Smile!

[Tools] -> [Options] -> [Query Results] -> [SQL Server] -> [Results to Grid] : specify the option to "Include column headers when copying or saving the results".

Posted: Jan 09 2009, 10:46 AM by DaveRuijter | with no comments
Filed under: