如何把XML转换成SQL Server临时表

例子才是王道：

 

declare @xml as xml;
set @xml='<root>
<item key="key1" value="1" />
<item key="key2" value="2" />
</root>';

declare @doc as int;
declare @list as table(key varchar(30), value int);

exec sp_xml_preparedocument @doc out, @xml;


insert into @list
select * from openxml(@doc, 'root/item')
with
(
key varchar(30),
value int
)
exec sp_xml_removedocument @doc;


select * from @list;