日期:2014-05-17  浏览次数:20382 次

存储过程处理XML问题?
存储过程怎样把XML格式数据插入到临时表? 
XMLXML内容如下:

xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:updatable='true'>
<s:AttributeType name='no' rs:number='1' rs:writeunknown='true' rs:basecatalog='lkhz' rs:basetable='cOrder_d'
 rs:basecolumn='no'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='18' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='color' rs:number='2' rs:writeunknown='true' rs:basecatalog='lkhz' rs:basetable='cOrder_d'
 rs:basecolumn='color'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='6' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='plate' rs:number='3' rs:writeunknown='true' rs:basecatalog='lkhz' rs:basetable='cOrder_d'
 rs:basecolumn='plate'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='4' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='s1' rs:number='4' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='lkhz' rs:basetable='cOrder_d'
 rs:basecolumn='s1'>
<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='ID' rs:number='5' rs:basecatalog='lkhz' rs:basetable='cOrder_d' rs:basecolumn='ID' rs:keycolumn='true'
 rs:hidden='true' rs:autoincrement='true'>
<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row no='AW20410           ' color='-     ' plate='B' ID='8'/>
</rs:data>
</xml>
存储 XML String