This is from XML to sqlserver

exce sp_xml_preparedocument @inthandle int output,@xmldocument

select * from openxml(@inthandle,'/root/customer',2)
with (customerid varchar(10),
      contactname varchar(20))

exec sp_xml_removedocument @inthandle