sql ½âÎöxml ÎÊÌâÇó½Ì

SQL code:
<?xml version="1.0" encoding="UTF-8" ?>
<response>
<status>0</status>
<desc>success</desc>
<content>
<field name="²âÊÔÃû" type="string">²âÊÔÄÚÈÝÖµ</field>
</content>
</response>



Çë´ïÈËʹÓô¢´æ¹ý³Ì ½âÎö³öÈçÉÏxmlÖÐfield ×ֶεÄ"²âÊÔÄÚ´ÓÖµ"


ÔÚÍøÉÏÕÒÁËÒ»¶Î´úÂë,²»Ö§³ÖxmlÖаüº¬ÈκÎÖÐÎÄ×Ö·û.

¸½ÔÚÍøÉÏÕҵĴúÂë
SQL code:
DECLARE @HDOC INT --Îĵµ¾ä±ú
DECLARE @XMLSTRING VARCHAR(200) --XML×Ö·û´®
SET @xmlString ='<?xml version="1.0"?>
<ROOT>
<USER ID="1" Name="SBQCEL"/>
<USER ID="2" Name="PEACELI"/>
<USER ID="3" Name="SHEEPCHANG"/>
</ROOT>'
--ʹÓÃϵͳ´æ´¢¹ý³ÌSP_XML_PREPAREDOCUMENT·ÖÎöXML×Ö·û´®
EXEC SP_XML_PREPAREDOCUMENT @HDOC OUTPUT, @xmlString
--ʹÓÃOPENXML´ÓSQL Server µÄÄÚ²¿»º´æ²éѯÊý¾Ý
SELECT * from OPENXML(@HDOC,N'/ROOT/USER')
WITH
(
ID INT,
Name VARCHAR(10)
)
--ʹÓÃϵͳ´æ´¢¹ý³ÌSP_XML_REMOVEDOCUMENTÊÍ·ÅÄÚ´æ
EXEC SP_XML_REMOVEDOCUMENT @HDOC

---

Õâ¸ö²»¶®  °ï¶¥

---

SQLServer2005