sql xml 入门 (二）

DECLARE @myDoc xml

    --http://www.paymob.cn
     --话费充值api,充值api,话费充值接口,手机话费充值,车贝手机,贝萌手机,移动话费充值,联通话费充值,电信话费充值,话费缴费,自动充值,话费卡充值，充值卡兑换

SET @myDoc = '<Root>

<ProductDescription ProductID="1" ProductName="Road Bike">

<Features>

  <Warranty>1 year parts and labor</Warranty>

  <Maintenance>3 year parts and labor extended maintenance is available</Maintenance>

</Features>

</ProductDescription>

</Root>'

select

 T.C.value('Warranty[1]','varchar(max)') as Warranty,

 T.C.value('Maintenance[1]','varchar(max)') as Maintenance

from @myDoc.nodes('//Root/ProductDescription/Features') as T(C)