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
a tech junkie and a software developer.
a apple fan and an avid photographer.
a frequent traveller and loves art and graphic novels.
My coder is trying to convince me to move to .net from PHP. I have always disliked the idea because of the costs. But he’s tryiong none the less. I’ve been using WordPress on numerous websites for about a year and am concerned about switching to another platform. I have heard very good things about blogengine.net. Is there a way I can import all my wordpress content into it? Any help would be really appreciated!
Hi Daniel
My question to you is what additional benefits will you get from BlogEngine.net that you can’t get from WordPress?
It will benefit your developer if he/she is a .NET developer and not a PHP developer.
There’s no straight forward method to port from WordPress to BlogEngine. Tools that are available will require some work under the bonnet.