Next, inside the WITH clause, we need to define the name and type of the attributes that you want returned. The mode value of 1 returns the attributes only. The OPENXML function takes three parameters: the handle to the XML document, the path of the node for which we want to retrieve the attributes or elements and the mode. Next, we use the OPENXML function to read the contents of the XML document. It takes the handle and the document variable as parameters and creates an association between them. The sp_xml_preparedocument performs this task. To read the attributes and elements of the XML document, we need to attach the handle with the XML document. Next, we create a handle for the XML document.

At this point in time, the XML document is loaded into the memory. Next using the SELECT statement we print the contents of the XML file. In the script above we declare an XML type variable The variable stores the result returned by the OPENROWSET function which retrieves XML data in binary format.

Best xml editor nested