Wednesday, March 7, 2012

FOR XML AUTO returns too many additional elements

Hi, I use the FOR XML AUTO to retrive native XML from a database with:

SELECT [xml] FROM myxml WHERE id = 81 FOR XML AUTO, elements, root('ROOT')"

However it returns the database name and table name as parent elements. How can I return just my raw XML data without additional elements:

XML is Stored:

<ROOT>

<CHAPTER>

<TITLE>This is a test</TITLE>

</CHAPTER>

</ROOT>

Returns:

<databasename>

<tablename>

<ROOT>

<CHAPTER>

<TITLE>This is a test</TITLE>

</CHAPTER>

</ROOT>

</tablename>

</databasename>

I got it. I used XQuery to get the xml...

No comments:

Post a Comment