Summary
XML is ubiquitous nowadays, and in this chapter, we have taken a fairly extensive tour of the FOR XML clause and its various options, as well as the xml data type and its data manipulation mechanisms, XQuery and XML DML. As you have seen, SQL Server provides a rich feature set of XML technologies. At times, you will want to store XML in the database, other times you will want to serve XML from the database, and still other times you may want to do both. Whatever your XML needs are, the xml data type allows you to work with XML natively at the database level. Armed with this data type and the ability to query it using XQuery, you can fully exploit the power of XML inside your SQL Server databases and build smart, XML-aware applications. ...
Get Programming Microsoft® SQL Server® 2012 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.
