SQL Server Management Studio - Copy With Headers

SQL Server Management Studio - Copy With Headers

  • Comments 3

I'm writing this on the train to Seattle to visit with a customer this morning - I'm thankful for Wireless! Although setting up a wireless network for a train is a really big thing, sometimes it's the smaller things that make us happy.

In SQL Server Management Studio (SSMS), you can open a query window and have the results sent to a grid output. Sometimes you want to copy some (or all) of those rows out to another application like Excel or Word. And one of the most frustrating things is that you don't get the headers of the rows of what you just copied. Well, it's a problem no more. Run a query, select your rows, and then right-click them. We've now got a menu item called "Copy with Headers" that does exactly what it says.

Oh, there's another feature that you might not be aware of - you can hold down the CTRL (Control) key and click on various cells and then right-click those for a copy or copy with headers.

Leave a Comment
  • Please add 2 and 2 and type the answer here:
  • Post
Page 1 of 1 (3 items)