Click Developer > Import. If you don’t see the Developer tab, see Show the Developer tab. In the Import XML dialog box, locate and select the XML data file (. xml) you want to import, and click Import.

How do I get data from XML format in SQL Server?

SQL Server lets you retrieve data as XML by supporting the FOR XML clause, which can be included as part of your query. You can use the FOR XML clause in the main (outer) query as well as in subqueries. The clause supports numerous options that let you define the format of the XML data.

How can I open XML file in SQL?

1. CREATE TABLE PointsXML — Create table for raw XML file.
2. (
3. Id INT IDENTITY PRIMARY KEY,
4. XMLData XML,
5. LoadedDateTime DATETIME.
6. )
7. INSERT INTO PointsXML(XMLData, LoadedDateTime) — Insert xml data into table.
8. SELECT CONVERT(XML, BulkColumn) AS BulkColumn, GETDATE()