SSMS: Results to Grid – With Headers

So, this sounds like a small thing; and it really is.  But how many times have you fought with the output of a query and tried to dump it into excel, but not gotten the headers?  Or, how many times have you instead then used the query to text and had to go through the data import process, which might or might not work properly?

Well, earlier this week I found an option in SSMS (2005 and 2008) that most of my co-workers and I were unaware:

Include Column Headers when Copying or Saving the Results.

image

Advertisements
This entry was posted in SQL and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s