In this lesson, you learn how to generate well-formed XML from relational data. You also learn about the XML datatype and how it is used.
XML has become a standard mechanism by which to exchange, distribute, and persist data. Although SQL Server is a relational DBMS, and relational data is very different from hierarchical XML data, there are often compelling reasons to obtain SQL Server data as XML, and to store XML data within SQL Server tables.
Here are the three primary areas of interest concerning SQL Server’s XML support:
SELECT to retrieve data, returning it as well-formed ...