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.
Version reviewed: 3.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. In conclusion: This program's features and functionality impressed me, so I recommend you try it too. You can choose where you want to preview the output, and whether you want to save it to a HTML file. Pluses: Applying XSL templates to a XML file is supported. In my opinion the program's functionality is more than enough for an average and even for an advanced user. This software's purpose is to allow the user to view and edit any XML file in a user friendly manner. New attributes can be added in the "Attributes" window. The attributes of each node can be modified or deleted. Also, in the treeview that displays the nodes you can use drag and drop, or you can move up or down any of the nodes.
The program also supports adding text, an attribute, a child element, or a CDATA section to any of the XML nodes. There are two more windows available in the program: one for editing the raw XML source file, and another one for viewing images embedded in the XML. If you select one of the nodes, its attributes appear in a separate window and you can modify them. When you start the program and open a file, you can see the file's entire XML structure in a window. XML Viewer can be used not only to view XML files but also to edit them.
0 kommentar(er)
