SQL Server 2000 XML Advanced Programming

Author: (USA) Burke
Publisher:
Publish Date: 2003-01-01
Features: SQL Server 2000's key feature is XML and the enhanced capabilities it provides. This includes the ability to use XML documents to update databases, access SQL Server via HTTP, and retrieve data from the database in XML format. This book not only covers critical issues but also delves into advanced topics in depth, including XDR and XSD Schema (which were added in Web Release 2), as well as features added in Web Release 1, such as Updategram and XMLBulkLoad. The book also includes five real-world cases that appropriately demonstrate how SQL Server 2000's XML features are best utilized by various technologies (such as ASP, C#, and SOAP). The book primarily discusses the XML features of Microsoft SQL Server 2000. The first ten chapters comprehensively cover advanced topics such as SQL Server 2000, XML, XML Templates, XPath, FOR XML, OPENXML, XDR Schema, XML View, Updategram, and XMLBulkLoad. Subsequently, five examples are provided, offering good practices for integrating these XML features into SQL Server projects. The final three appendices mainly describe virtual directories and XMLViewMapper. This book is suitable for programmers with some SQL Server 2000 development experience, especially T-SQL developers with some XML experience.