Dynamically select Nodes in Xpath in SQL Server 2008

Question

I have following XML to parse in SQL Server 2008

<Root>
  <Document>
    <Body>
      <Component>
      </Component>
    </Body>
  </Document>
</Root>

I want to retrieve all the <Component> tags in my xml, the issue is that <Document> tag at times might not come, Hence my xpath query of (root/document/body) won't work. Is there way I can get all <Component> tags irrespective of presence of <Document> tag?

marc_s · Accepted Answer · 2011-10-31 18:25:07Z

2

You could always use an XPath query of

//component

to get all <component> elements in your entire document - no matter where they are and what other tags there are around it

answered Oct 31, 2011 at 18:25

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mikael Eriksson Over a year ago

Or like this if you want to be a little bit more specific. /Root//Body/Component

Collectives™ on Stack Overflow

Dynamically select Nodes in Xpath in SQL Server 2008

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related