TSQL XQuery Example

最新推荐文章于 2024-09-19 16:11:31 发布

AdamsLee

最新推荐文章于 2024-09-19 16:11:31 发布

阅读量480

点赞数

文章标签： tsql class list

本文链接：https://blog.csdn.net/AdamsLee/article/details/7058212

版权

declare @myDoc xml
set @myDoc = '<document>
<header>Alphabet</header>
<items>
<item id="a">a is for apple</item>
<item id="b">b is for balloon</item>
<ul id="link_list">
    <li><div class="h_link" link="" type="brand" bId="12745">bb</div></li>
    <li><div class="h_link" link="" type="mall" locId="125007">aa</div></li>
    <li><div class="h_link" link="" type="brand" bId="12746">bb</div></li>
    <li><div class="h_link" link="" type="shop" locId="58318">aa</div></li>
</ul>
</items>
</document>'
SELECT @myDoc.query('//items/item[@id="a"]')
SELECT @myDoc.value('(//div[@class="h_link"][@type="b"]/@bId)[1]', 'nvarchar(max)')