Monday, March 26, 2012

Retruning Stored XML in a XML EXPLICIT statement

I have data stored in the database in XML format.

The data looks like this...

<entries><entry name = "Scott" /></entries>

When I return it using an xml explicit statement, it is return like this...

"Scott" /></entries>"/>

Is there a way to force it to use the normal tags instead of sql changing it?SELECT * FROM table for xml auto, elements

No comments:

Post a Comment