Chapter 7
SQL Server and XML
SQL Server and XML are from different data universes. SQL Server is a relational database environment, and XML is a hierarchical data structure. Getting the two to talk to each other has been a challenge. With the release of SQL Server 2000 and the SQLXML infrastructure, Microsoft began making significant strides in integrating these disparate data environments. With each subsequent release, the toolset and the feature list gets better.
Now in SQL Server 2008, we have better XML support than ever. This chapter addresses these features and demonstrates how you can effectively integrate XML and relational data through SQL Server and its client applications.
In this chapter, you will learn to:
- Implement the FOR XML ...
Get Mastering SQL Server® 2008 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.
