[SQL ] XML 用node name篩選?

作者: YiMMiY (YiMMiY)   2018-02-23 10:37:08
MS SQL - 2012
各位版友們好
手邊有一個XML,如下
@xml = '
<row id='1'>
<AAA>zxc</AAA>
<BBB>asd</BBB>
<CCC>qwe</CCC>
</row>
<row id='2'>
<AAA>vbn</AAA>
<BBB>fgh</BBB>
<CCC>rty</CCC>
<DDD>jkl</DDD>
</row>
<row id='3'>
<AAA>sdf</AAA>
<DDD>xcv</DDD>
</row>
'
手邊還有一個TABLE,如下
Tb_DEF
COLA ...

Links booklink

Contact Us: admin [ a t ] ucptt.com