SQLServer XML 解析

DECLARE @dataSource XML  

SET @dataSource=' 
<root> 
  <info id="1">
    <user uid="001">
       <name>abc</name>
       <type>MG</type>
    </user>
  </info>
  <info id="2">
    <user uid="002">
      <name>Olive</name>
      <type>MG</type>
    </user>
  </info>
  <info id="3">
    <user uid="003">
      <name>xyz</name>
      <type>NMG</type>
    </user>
  </info>
</root>'

select @dataSource.value('((/root/info/user)[2]/@uid)[1]','nvarchar(20)')
select @dataSource.value('((/root/info/user)[2]/name)[1]','nvarchar(20)')

结果是 002 和 Olive