XML query result

Hi,

In SQL Server 2005 SP2, when I use a query like this:

SELECT f1, f2, f3
from myTable
for xml auto, elements

I always receive result on the same line, not formatted like a tree. Why ?

Query result example:
<MyTable><f1>A</f1><f2>10</f2><f3>1</f3></MyTable><MyTable><f1>A</f1><f2>10</f2><f3>1</f3></MyTable>

I want:

<MyTable>
<f1>A</f1>
<f2>10</f2>
<f3>1</f3>
</MyTable>
<MyTable>
<f1>A</f1>
<f2>10</f2>
<f3>1</f3>
</MyTable>

In Books Online, all query result are easily readable...

Thanks

shwac wrote:

> I always receive result on the same line, not formatted like a tree. Why ?
>
> Query result example:
> <MyTable><f1>A</f1><f2>10</f2><f3>1</f3></MyTable><MyTable><f1>A</f1><f2>10</f2><f3>1</f3></MyTable>
>
> I want:
>
> <MyTable>
> <f1>A</f1>
> <f2>10</f2>
> <f3>1</f3>
> </MyTable>
> <MyTable>
> <f1>A</f1>
> <f2>10</f2>
> <f3>1</f3>
> </MyTable>

How are you looking at the query? In SQL Server Management Studio you
can click on the XML column value and you will then get the XML display
in pretty printed (and editable) form in a separate tab.


--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/