O'Reilly logo

Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Lesson 27. Working with XML and JSON

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.

Using SQL Server XML Support

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:

Image Using SELECT to retrieve data, returning it as well-formed ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required