O'Reilly logo

Mastering SQL Server® 2008 by Gentry Bieker, Michael Lee

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

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

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