dbTalk Databases Forums  

Retrieve column headings from query

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools Retrieve column headings from query

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Retrieve column headings from query in the microsoft.public.sqlserver.tools forum.



Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
BillG_SD
 
Posts: n/a

Default Retrieve column headings from query - 05-13-2008 , 12:08 PM





I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise, I
have to manually type the column headings by hand.




Reply With Quote
  #2  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM





BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
  #3  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM


BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
  #4  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM


BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
  #5  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM


BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
  #6  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM


BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
  #7  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM


BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
  #8  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM


BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
  #9  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM


BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
  #10  
Old   
Russell Fields
 
Posts: n/a

Default Re: Retrieve column headings from query - 05-13-2008 , 12:27 PM


BillG_SD,

With SQL Server 2000 tools, I don't know a way to do this. However, with
SQL Server 2005 Management Studio, there is a option on the query result
sets.

Menu path Tools / Options brings up an Options form.

In the tree structure on the left side:
Query Results / SQL Server / Results to Grid

Click on the option: Include column headers when copying or saving the
results

And, of course, the 2005 tools can be used against SQL Server 2000 and it
all works the same.

RLF



"BillG_SD" <BillDO_NOT_SPAMGiovinetti (AT) NO_SPAMyahoo (DOT) com> wrote

Quote:
I'm using both SQL Server 2000 & 2005. I often perform queries and need to
copy the (grid based) results into Excel 2007. The problem is, the column
headings are not included. Is there a setting to change this? Otherwise,
I
have to manually type the column headings by hand.



Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top