Xml file

Does any one has experience of importing xml file into sql server ? I just got a barcode and it is contain of a link to download a file which is contain of an xml information. And I don't know to import it into my database. Hope any one can help what is the step or tutorial to import and store the information..



Please post sample xml minus any sensitive data?

See the answer with an example at the following URL. Disclaimer: I have not run the example but it looks correct. It also explains how to shred the XML, if you need to.

This is the link


That's a very suspicious looking link and a suspicious looking response. I advise people to not trust it and don't click on it.

can you please post the actual xml file content here instead of a link?