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
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