lrr81765
asked on
SQL XML Import
Given a table:
Zipcode (varchar(5))
Distance (integer)
and an XML file
<?xml version="1.0" encoding="utf-8" ?>
- <ArrayOfZipCodeDistances xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://skats.net/services/literalTypes">
- <ZipCodeDistances>
<ZipCode>45419</ZipCode>
<Distance>2</Distance>
</ZipCodeDistances>
- <ZipCodeDistances>
<ZipCode>45440</ZipCode>
<Distance>3</Distance>
</ArrayOfZipCodeDistances >
How do you import these into the table?
Zipcode (varchar(5))
Distance (integer)
and an XML file
<?xml version="1.0" encoding="utf-8" ?>
- <ArrayOfZipCodeDistances xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://skats.net/services/literalTypes">
- <ZipCodeDistances>
<ZipCode>45419</ZipCode>
<Distance>2</Distance>
</ZipCodeDistances>
- <ZipCodeDistances>
<ZipCode>45440</ZipCode>
<Distance>3</Distance>
</ArrayOfZipCodeDistances >
How do you import these into the table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Brett