a question about sql query analyzer

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

a question about sql query analyzer

Author

Topic

jeff06
Posting Yak Master

166 Posts

Posted - 2007-01-19 : 15:50:12

Is there a way to save the column title of a qurey result?
For example, I know how to copy the result in grid to an excel spread sheet, but I have to type the column name into the speadsheet.
Is there a way to avoid that?
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-19 : 15:54:09

Are you using SQL 2005? Change the setting in Tools -> Options

Peter Larsson
Helsingborg, Sweden

jeff06
Posting Yak Master

166 Posts

Posted - 2007-01-19 : 16:35:36

I check about....
The sql querey analyzer is versionb sql 8.00.194

TOOL-Option have too many choice, Can you give me some more detailed instruction?
THX
Jeff

X002548
Not Just a Number

15586 Posts

Posted - 2007-01-19 : 16:47:58

you could look at this

http://weblogs.sqlteam.com/brettk/archive/2005/04/13/4395.aspx

But DTS would be the easiest thing to create a spreadsheet

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-01-19 : 19:22:17

there is a really easy solution to this

1. Go to Tools-->Options in QA
2. Select Results tab
3. Change 'Default Results Target' to 'Results in Text'
4. Change 'Results output format:' to 'Tab Delimited'
5. Run your query
6. Copy/Paste the entire output from QA into Excel

-ec

jeff06
Posting Yak Master

166 Posts

Posted - 2007-01-26 : 16:26:05

Cool THX

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources