XML Import

[ntbuddy]

I have a program that saves inforamtion in XML format. Is there a way that I can e-mail the XML structure to my corporate office and then import it direct into SQL 2000?

Thanks, John

 

[JohnDTampaBay]

Check out

sp_xml_preparedocument

and the associated procedures in BOL. This procedure will prepare an xml document for querying as a rowset. Once that's done, you can query against it like any other table - including SELECTing from it to INSERT into another table.

Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.