create procedure procedureName
@xml xml
as
begin
insert into wannaInsertTableName <(xx,xx,xx)>
(
select x.c.value('ID[1]','int') as XX x.c.value('name[1]','varchar(50)')
from @xml.nodes('node') as x(c)
)
end
@xml 为参数,x.c.value('ID[1]','int') 其中id为xml中的节点名称,最后的node为单个对象的节点!