SQL获得xml节点及值

Question

给任何一个xml文件,如何按节点-节点值 对 形式提取所有节点?

Answer 1

比如
<?xml version="1.0" encoding="UTF-8">
<ProvB>
  <SvcCon>0100</SvcCon>
  <Msg>100</Msg>
  <Context/>
  <ParamList>
     <Param>
       <ParamKey>code<ParamKey>
       <ParamValue>1<ParamValue>
     </Param>
     <Param>
       <ParamKey>opr<ParamKey>
       <ParamValue>22<ParamValue>
     </Param>
  </ParamList>
  <ConfigList>
       <ConfigKey>config<ConfigKey>
       <ConfigValue>1<ConfigValue>
  </ConfigList>
</ProvB>
我希望得到
SvcCon, 0100
Msg, 100
Context,null
ParamKey, code
ParamValue, 1
ParamKey, opr
ParamValue, 22
ConfigKey,config
ConfigValue,1若要想同时得到路径呢,可以吗?像这样
SvcCon, 0100, ProvB/SvcCon
Msg, 100, ProvB/Msg
Context,null, ProvB/Context
ParamKey, code,  ProvB/ParamList/Param/ParamKey
ParamValue, 1, ProvB/ParamList/Param/ParamValue
ParamKey, opr, ProvB/ParamList/Param/ParamKey
ParamValue, 22, ProvB/ParamList/Param/ParamValue
ConfigKey,config, ProvB/ConfigList/ConfigKey
ConfigValue,1, ProvB/ConfigList/ConfigKey我只知道把xml文件看成一个字符串,后面怎么提呢?SQL里的正则表达式怎么用呢? 我连有哪些节点和各个节点的位置都不知道啊,怎么定位呢??希望大家指点

Answer 2

http://topic.csdn.net/u/20080131/16/76a9e86f-5c02-4b92-ad7a-7f606f5f6814.html?seed=1017590478

Answer 3

http://topic.csdn.net/u/20071210/15/9e4f6893-eb1c-4907-a0cf-7a1f1e6647cd.html
http://topic.csdn.net/u/20071130/17/1c98c1bd-09e7-4adb-8a9a-1befef2c73c0.html