Since the 2000 release, SQL Server has supported XML integration via SQLXML. SQLXML was designed as a “bridge” technology between XML and relational data. Much of the functionality available through SQLXML is now exposed by the SQL Server xml data type and other T-SQL and .NET functionality. In fact, Microsoft has announced plans to remove SQLXML from the SQL Server 2008 installer in the production release. SQLXML is still an important topic, however, because there are many applications that have been built on this functionality which will require ongoing support. In this chapter, I will discuss SQLXML features, functionality, and options.
Unable to display preview. Download preview PDF.