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: