DECLARE @xmlDoc XML
SET @xmlDoc='<?xml version="1.0" encoding="gb2312"?><Fields><fItem1 level="1" levelname="基本一级">5000.00</fItem1><fItem2 level="1" levelname="绩效一级">1000.00</fItem2></Fields>'
select @xmlDoc
SELECT
T.C.value('local-name(.)','varchar(20)') as name,
T.C.value('(.)[1]', 'varchar(40)') as tValue
FROM @xmlDoc.nodes('/*/*') AS T ( C )
读取结果如下:
name tValue
fItem1 5000.00
fItem2 1000.00
将xml里面的节点读取为字段值