element centric XML for XML explicit - suggestion needed

my xml would be like.
<X>
-<XY>
-<XYZ>
<![CDATA[ hello adkfsd ]]>
</XYZ>
-<XYZ1>
<![CDATA[ hell adkfsd ]]>
</XYZ1>
<XY>
<XY1>
...
</XY1
</X>
it is very element centric . All the data comes from a single table.
here just for mentioning the parent tag for the datas i need to write a
select.
i wrote a query which had 6 selects and got the XML.
two of the select querys were written just to include the name for the
parent tag.
can someone pls tell me if its possible to improvise..
is it possible to use for xml auto and get CDATA..
waiting for ur replies,
tobyToby wrote:

> my xml would be like.
> <X>
> -<XY>
> -<XYZ>
> <![CDATA[ hello adkfsd ]]>
> </XYZ>
> -<XYZ1>
> <![CDATA[ hell adkfsd ]]>
> </XYZ1>
> <XY>
> <XY1>
> ...
> </XY1
> </X>
>
> it is very element centric . All the data comes from a single table.
> here just for mentioning the parent tag for the datas i need to write a
> select.
> i wrote a query which had 6 selects and got the XML.
> two of the select querys were written just to include the name for the
> parent tag.
> can someone pls tell me if its possible to improvise..
> is it possible to use for xml auto and get CDATA..
Do you really need CDATA Sections? They are often unnecessary.
See http://xml.silmaril.ie/authors/cdata/
///Peter|||I have to second Peter's sentiment about CDATA sections. CDATA sections are
meant for helping manual authoring of XML documents and should not be used
otherwise.
And no, FOR XML AUTO does not provide a way to generate CDATA sections. You
would have to use the EXPLICIT mode.
Best regards
Michael
"Peter Flynn" <peter.nosp@.m.silmaril.ie> wrote in message
news:3sahonFn6kgqU4@.individual.net...
> Toby wrote:
>
> Do you really need CDATA Sections? They are often unnecessary.
> See http://xml.silmaril.ie/authors/cdata/
> ///Peter
>