Question: how to import xml data in sql server?
Answer: Step 1 – Create table to store imported data. Let's create a simple table that'll store the data of our customers. ... 
Step 2 - Create Sample XML File. Below is sample XML data. ... 
Step 3 – Importing the XML data file into a SQL Server Table. ... 
Step 4 - Check the Imported XML Data.