Lesson 27. Working with XML

In this lesson, you’ll learn how to generate well-formed XML from relational data. You will also learn about the XML datatype and how it is used.

Understanding SQL Server XML Support

Note: SQL Server 2005 Only

This lesson covers functionality that was introduced in SQL Server 2005 and is not available in earlier versions of SQL Server.

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 ...

Get Sams Teach Yourself Microsoft now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial