Programming Microsoft SQL Server 2000 With XML (Pro-Developer)

Use XML and SQL Server® to turn business data into powerfully integrated solutions for employees, customers, and partners.

Discover how to transform your organizations relational databases into potent e-commerce, business-to-business, and Web applications with this core reference for solution developers. The rich XML support in Microsoft SQL Server™ 2000 makes it easy to map XML and relational data with familiar standards such as XPath, XDR schemas, XSL Transformation, HTTP, and OLE DB, as well as newer tools. Youll learn how to retrieve XML data from the database, insert XML data into the database, and manipulate it in extensible database solutions. And youll examine real-world solutionsincluding knowledge-management systems and high-volume electronic retail databasesthat demonstrate how to use SQL Server and XML to move your critical business processes to the Web. An appendix discusses XML specifics for SQL Server developers. Topics covered include:

SQL, XML, and the business Internet
Retrieving XML data with Transact-SQL, Microsoft ActiveX® Data Objects (ADO), HTTP database publishing, XML templates over HTTP, and mapping schemas
Inserting XML data with the OpenXML function
XDR schemas
XSL Transformation
XML support in the Internet Information Services MMC snap-in tool
Using updategrams and the XML bulk load component
Building an e-commerce solution

INCLUDED ON CD-ROM:
A searchable electronic version of the book
Code samples and real-world applications