Hi All,

I want to export a rsultset of an sql query to a text file, from the query analyser, can you please help me in this aspect.


regards
Sasidhar

thanks,
Sasidhar

__________________
thanks,
Sasidhar

You mean to help you in copy paste the result from query analyser?

Try this.

Use CTRL + D to have results in GRID.
Once you execute the query in sql QA, Select the result and can right click to choose SAVE SELECTION, which saves the result in CSV format.

Is that what you are looking for?

Hope that helps.
Cheers!

_________________________
-Vijay G
Strive for Perfection

Hello,

You can also copy/paste from the results screen to a text file.

Brian

Is there a way to include the column headings, using this method?

Then you got to use TEXT mode for result pane (CTRL + T). Execute the query and copy/paste from the result pane to a text file. This includes the column heading too.

PS : But SAVE SELECTION option would not appear when using TEXT result mode

Cheers!

_________________________
-Vijay G
Strive for Perfection

Thanks for this,
Notepad was the missing piece, I was pasting the results straight into Excel and getting the results all in one column.

Thanks

If you paste in Excel, use Grid mode, but you got to compromise on missing the column header part.

If you use notepad, text mode is the right thing to have column header part too in it.

Cheers!


_________________________
-Vijay G
Strive for Perfection