¹ØÓÚxmlµÄ½âÎö

<priceParameters>
<parameter Prop1="°×É«|FFFFFF" Prop2="3ÆÚ" Prop3="ÖйúÒøÐÐ" Prop4="XL> </parameter>
    <parameter Prop2="3ÆÚ" Prop4="ÖйúÒøÐÐ"> </parameter>
<parameter Prop3="ÖйúÒøÐÐ"> </parameter>
<parameter Prop4="XL"> </parameter>
  </priceParameters>

prop1,prop2,prop3,prop4ÊÇÊý¾Ý×ֶΠ¶¼¿ÉΪ¿Õ

°×É« xl¶¼ÊÇ×Ö¶ÎÖµ
prop1,prop2,prop3,prop4 ¿ÉÒÔ²»Í¬Ê±³öÏÖ


Õâ¸öÈçºÎ½âÎöÈë¿â£¿

---

Èç¹ûÊǶàÌõprop1µÄʱºò.xmlÊý¾ÝÊÇÔõÑùµÄ?

---

Ŷ.¿´´íÁË.

---

SQL code:
declare @x xml;
set @x = '<priceParameters>
<parameter Prop1="°×É«|FFFFFF" Prop2="3ÆÚ" Prop3="ÖйúÒøÐÐ" Prop4="XL"> </parameter>
<parameter Prop2="3ÆÚ" Prop4="ÖйúÒøÐÐ"> </parameter>
<parameter Prop3="ÖйúÒøÐÐ"> </parameter>
<parameter Prop4="XL"> </parameter>
</priceParameters> '


select t.x.value('@Prop1','nvarchar(20)') as prop1,
t.x.value('@Prop2','nvarchar(20)') as prop2,
t.x.value('@Pro3','nvarchar(20)') as prop3,
t.x.value('@Prop4','nvarchar(20)') as prop4
from @x.nodes('//para