Set based operation on XML

  • Hi,

    I am kind of novice to XML and trying to figure out my way through our design.We have a table which stores the XML string which is basically and stores data audit of the fields that got changed in the database.

    Is there a set based operation which would help me generate relational values for the all the attributes ??

    Any external links ; tutorials would help.Thanks

  • Are you talking about querying the XML data so that it reads like table (columns and rows)?

    If so, then XQuery is what you need. The functions you'll most likely need are "nodes" and "value".

    If you can post some sample XML, we can help with writing a query for it.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply