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