Professional SQL Server 2000 Xml

by Paul J Burke Et Al

• ISBN13: 9781861005465
• ISBN10: 1861005466
• Format: Trade Paper
• Copyright: 2001-06-28
• Publisher: Springer-Verlag New York Inc
• More Book Details
• Purchase Benefits

Summary

The most important new features of SQL Server 2000 concern XML and the added functionality that it provides. This includes the ability to use XML documents to update your database, access SQL Server through HTTP and retrieve data from your database in XML format. Building extensively on the new features introduced in Professional SQL Server 2000 (1-861004-48-6) this book goes beyond just the key issues and provides blanket in-depth coverage of advanced topics, including both XDR and XSD schemas (support for which has been added in the new Web Release 2), and additions in Web Release 1, such as Updategrams and XML Bulk Load. This book also includes five real-world case studies that show exactly how the XML capabilities of SQL Server 2000 can best be exploited with technologies as diverse as ASP, C#, and SOAP.

Table of Contents

Introduction	1	(6)
An Introduction to XML	7	(22)
Overview of XML in SQL Server	29	(14)
FOR XML	43	(46)
OPENXML	89	(46)
XDR Schemas	135	(48)
XSD Schemas	183	(28)
XML Templates and Views	211	(22)
XPath	233	(22)
Updategrams	255	(34)
XML Bulk Load	289	(216)
Enhancing Legacy Applications with XML	315	(32)
An Order Entry System Using VB and XML	347	(68)
Creating an XML Reporting System	415	(26)
SOAP	441	(26)
A .NET Case Study	467	(38)
Appendix A: Creating and Configuring Virtual Directories	505	(22)
Appendix B: Microsoft XML View Mapper 1.0	527	(52)
Appendix C: Web Release 2 - Beta 1	579	(2)
Index	581