Howto also copy/paste column name in Query Analyze

• pkeefe

  SSC Enthusiast

  Points: 107

  More actions

  November 26, 2003 at 10:15 am

  #83570

  Is there any way to include the column names when I copy and paste the grid results from Query Analyzer?

  Pete

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  November 26, 2003 at 11:42 am

  #483804

  Not that I know. Unless you include first the columns that you need to copy in the select clause, so they are all contiguous.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  November 26, 2003 at 12:51 pm

  #483814

  Or change the output to text instead of grid.

• philcart

  SSC-Forever

  Points: 47794

  More actions

  November 26, 2003 at 4:32 pm

  #483841

  If you're copying and pasting into Excel, output to text and change the results to tab-delimited.

  Then you can copy and paste the whole lot straight into Excel.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 27, 2003 at 3:59 am

  #483881

  Also you can do this with a view in EM. After opening the view, mark the columns, Ctr+C and paste.

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]