Series: XML

XML stands for eXtensible Markup Language. XML was designed to store and transport data. XML plays an important role in many different IT systems and is often used for distributing data over the Internet. XML stores data in plain text format. This provides a software- and hardware-independent way of storing, […]

XML Introduction

One online XML editor I found is called It will, among other things, convert your XML file to an XSD file for you. An XML Schema describes the structure of an XML document. The XML Schema language is also referred to as XML Schema Definition (XSD). The purpose of […]

XML Online Editor

This post continues from the post on XML Trees and discusses the two different styles of writing XML documents. Generally you should choose elements over attributes, with the exception of metadata, as explains. In the first example gender is an attribute. In the last, gender is an element. Both […]

XML Attributes vs. Elements

XML documents form a tree structure that starts at “the root” and branches to “the leaves“. XML documents are formed as element trees. An XML tree starts at a root element and branches from the root to child elements. All elements can have sub elements (child elements). The terms parent, […]

XML Tree

DOM stands for Document Object Model. To best understand what the DOM is, we will briefly discuss the HTML DOM first. When a web page is loaded, the browser creates a Document Object Model of the page. The DOM is a W3C (World Wide Web Consortium) standard. The DOM defines […]


XPath is a major element in the XSLT standard. XPath can be used to navigate through elements and attributes in an XML document. With XSLT you can transform an XML document into HTML. XSLT (eXtensible Stylesheet Language Transformations) is the recommended style sheet language for XML. XSLT is far more […]

XML and XPath

A really good source of SQL Server information is the website SQL Server Central. If you are interested in learning about XML in SQL Server you can have a look at their Stairway to XML series of articles. The XML data type is discussed in the second level. The XML […]

SQL Server XML Data Type