Here’s a SQL Server Tip

Posted on July 29, 2010
Filed Under Database | Leave a Comment

How many times have you asked this question when you run a query. How do I copy the query result with the column names into Microsoft Excel?

In the SQL Server Management Studio, in the Tools menu, select Tools > Options > SQL Server > Results to Grid

Then check the Include column headers when copying or saving the results checkbox and click on OK.

That’s it. The next time you run a query, copy the query result, paste in Excel and voila, the column names are pasted together with the data.

Sphere: Related Content

Other Related Posts:

Here’s your chance to become the next Picasso

MCTS Microsoft Office SharePoint Server 2007 Configuration

What is an Internet Server?

Sharepoint Server 2007 Trial

Understanding WSS 3.0 in five minutes

If you've enjoyed reading this post then why not subscribe to received updates by email.

Enter your email address:

Delivered by FeedBurner

 Email This Post

Trackback This Post

Comments

Leave a Reply

Name (required)

Email Address(required)

Website

Notify me of followup comments via e-mail