SQLServer2005 怎样查询带有命名空间的XML节点,
<bk:book genre="novel" bk:genre="fiction"
xmlns:bk="urn:xmlns:25hoursaday-com:bookstore">
<bk:title>The Confidence Man</bk:title>
<bk:author>
<bk:first-name>Herman</bk:first-name>
<bk:last-name>Melville</bk:last-name>
</bk:author>
<bk:price>15.0</bk:price>
</bk:book>
在上面的XML里面,我想查询book下面的price节点,应该怎么用Xpath定位到它
恳请会的朋友帮帮忙,万分感激!
<bk:book genre="novel" bk:genre="fiction"
xmlns:bk="urn:xmlns:25hoursaday-com:bookstore">
<bk:title>The Confidence Man</bk:title>
<bk:author>
<bk:first-name>Herman</bk:first-name>
<bk:last-name>Melville</bk:last-name>
</bk:author>
<bk:price>15.0</bk:price>
</bk:book>
在上面的XML里面,我想查询book下面的price节点,应该怎么用Xpath定位到它
恳请会的朋友帮帮忙,万分感激!
顶!
***.query('declare namespace bk="urn:xmlns:25hoursaday-com:bookstore"; /bk:book/bk:price') ***是XML列的列名