Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    60

    Unanswered: 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...

    &quot;Scott&quot; /&gt;&lt;/entries&gt;"/>

    Is there a way to force it to use the normal tags instead of sql changing it?

  2. #2
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    try this....

    SELECT * FROM table for xml auto, elements

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •