SQL Server Journey with SQL Authority

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology | 18 Comments

18 Responses

1. on July 12, 2007 at 7:22 am | Reply Angel

   It worked Fine!!!! Thanks A lot.
   Saludos desde Panama

   
   
2. on August 8, 2008 at 2:42 am | Reply Jon-Paul Lenczuk

   This worked for me like a charm! I was wondering how to do that without having to manually type the headings in Excel! Thanks!

   
   
3. on August 13, 2008 at 11:35 am | Reply Aroop

   Thank you a lot!!!

   
   
4. on April 9, 2009 at 4:45 pm | Reply Parmod Bhardwaj

   Do we have any other option beside this ?

   Reply must be appriciated !

   Thanks !

   Parmod Bhardwaj

   
   
5. on June 12, 2009 at 2:17 am | Reply flohack

   Thank you!

   Searched for this option since a long time. Drives you crazy!

   regards Florian

   
   
6. on June 26, 2009 at 11:54 pm | Reply selva

   This is a great tip!!! I was searcning this very long time. Thanks

   
   
7. on July 22, 2009 at 9:38 pm | Reply Marvelous mapurazi

   thanks a span buddie-it worked wonders for couldnt take the typing no more worse off for large queries

   
   
8. on November 30, 2009 at 5:43 am | Reply Mona

   THanks a lot !! I got this site after a lot of effort, the TIP worked just as desired. WOuld recommend this to everyone !!

   
   
9. on December 17, 2009 at 8:59 pm | Reply Alan Winn

   Excellent info — thank you very much! Mr. Dave, you are the man!!

   
   
10. on February 22, 2010 at 11:17 am | Reply richa

    Thanks alot!!! well i should be knowing that.. but anyways better late than never.

    
    
11. on February 26, 2010 at 10:50 pm | Reply Lydia

    Ah, so that’s how it’s done – good tip, thanks.

    
    
12. on April 1, 2010 at 3:21 pm | Reply Saurabh

    Thanks Mr. Dave.
    This is coimgn as a real help to me.
    Keep up the great work. :-)

    
    
13. on September 6, 2010 at 8:51 pm | Reply mendel

    a: thanks, I can’t tell you how many times I looked for this, and I never noticed that I can change the format of the output.

    b: just a note if you have any numbers with leading zeros in the data (some zipcodes, etc): if you save the file with a csv extension excel will open it and drop the zeros, if you save it as .txt and then open it in excel you will get a text import wizard, the wizard will allow you to set that column as text so it comes in correctly.

    
    
14. on October 20, 2010 at 5:09 pm | Reply Mohiuddin

    Thanx a lot….

    
    
15. on September 1, 2011 at 1:00 pm | Reply rajitha

    Thanks a lot ,real help to me.

    
    
16. on December 7, 2011 at 3:56 pm | Reply SAM

    Thx…Really Appreciated

    
    
17. on September 26, 2012 at 7:01 am | Reply SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #026 – Video « SQL Server Journey with SQL Authority

    [...] Copy Column Headers in Query Analyzers in Result Set [...]

    
    
18. on May 4, 2013 at 7:01 am | Reply SQL SERVER – Weekly Series – Memory Lane – #027 | SQL Server Journey with SQL Authority

    [...] Copy Column Headers in Query Analyzers in Result Set Another very popular request which I transformed into SQL in Sixty Seconds Video. [...]

    
    

Leave a Reply Cancel reply

Enter your comment here...

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

Email (required) (Address never made public)

Name (required)

Website

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

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

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

Cancel

Connecting to %s

Notify me of follow-up comments via email.

Notify me of new posts via email.