IanJoshua

 Profile Answers by IanJoshua 

• Jul 8th, 2008

 

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