a very simple question

hi, there this is a very simple question and Im sorry if it sounds to simple to post.

My problem is that my query returns a long result set in a very long row, the row is so long that I cant see all the result, when I try to expand the page, it still isnt enough to see all the results, and scrolling dosnt help either, I tried select all and copying the reults to a file, but all that does is only copy what can be done on screen.

what I would like to know is (1) how can adjust query analyser so that i can see all the reults

(2) is it possible to get the results returned as several rows, rather than one row, thanks

this is my query:

select * from employees
where employeeid = 1
for xml auto, elements

thanks very much for any help

hi,

you can save that to an XML file

and open it with an XML reader/parser

or simply internet explorer

regards,

joey

|||

Hello,

This is the problem due to allocation of maximum char per column.

do one thing open query analysier -> click on tools -> select option

then select the results tab set 8000 for maxi. char per columns.

:-)

|||

Hello,

This is the problem due to allocation of maximum char per column.

do one thing open query analysier -> click on tools -> select option

then select the results tab set 8000 for maxi. char per columns.

and also you cannot see all the entire value in query analyzer. so RtClk in QueryAnalyzer and select "Results to file..." (Short cut Ctrl+Shift+F). while executing that query Query analyzer prompts you to save the results to some file, so give a file name. after Query execution was completed go that file then you can get all the data in each column(Max 8000 characters per column).

sql