摘要： 例子才是王道： 1 declare @xml as xml; 2 set @xml='<root> 3 <item key="key1" value="1" /> 4 <item key="key2" value="2" /> 5 </root>'; 6 7 declare @doc as int; 8 declare @list as table(key varchar(30), value int); 9 10 exec sp_xml_prepar 阅读全文