sqlserver2008对XML的操作

sqlserver2008对xml的解析：

DECLARE @idoc int
DECLARE @doc varchar(8000)
SET @doc='
<xml>
<product productCode="1111" inprice="1"  saleprice="2"  costprice="3"/>
<product productCode="2222"  inprice="2"  saleprice="3"  costprice="4"/>
<product productCode="3333"  inprice="3"  saleprice="4"  costprice="5"/>
<product productCode="4444"  inprice="4"  saleprice="5"  costprice="6"/>
</xml>
'
PRINT len(@doc)
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
SELECT    *
FROM       OPENXML (@idoc, '/xml/product',3)
           WITH (productCode  varchar(10) './@productCode',
           inprice  money './@inprice'