xpath for xquery in SQL

Posted by Haroldis on Stack Overflow See other posts from Stack Overflow or by Haroldis
Published on 2010-12-30T12:48:07Z Indexed on 2010/12/30 12:54 UTC
Read the original article Hit count: 254

Filed under:
|
|

Hi all, I have a xml filed in sql table

the xml have the structure like these

<root>
<element>
<sub name="1">
<date>the date <date>
</sub>
<sub name="2">
<date>the date <date>
</sub>
<sub name="3">
<date>the date <date>
</sub>
.....
<element>
</root>

how i can get the date of the element with the name 1?

I have prove :

 /root/element/sub[Name = "1"]/date/text()

but nothing hapen.

any ideas?

© Stack Overflow or respective owner

Related posts about sql

Related posts about xpath