DECLARE @XML XML
SET @XML = '<row>
<NodeID>1</NodeID>
<NodeText>鼻咽部</NodeText>
<DepartmentID>1</DepartmentID>
</row>
<row>
<NodeID>2</NodeID>
<Parent>1</Parent>
<NodeText>血管</NodeText>
<DepartmentID>1</DepartmentID>
</row>
<row>
<NodeID>3</NodeID>
<Parent>1</Parent>
<NodeText>睾丸癌</NodeText>
<DepartmentID>1</DepartmentID>
</row>'
SELECT
doc.node.value('NodeID[1]', 'varchar(5)') as ID
,doc.node.value('Parent[1]', 'varchar(32)') AS Parent
,doc.node.value('NodeText[1]', 'varchar(32)') AS NodeText
,doc.node.value('DepartmentID[1]', 'varchar(32)') AS DepartmentID
FROM @XML.nodes('/row') AS doc(node)
