| |
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 (1861004486) this book goes beyond just the key issues and provides blanket indepth 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 realworld 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. This book covers: An introduction to XMLHow to retrieve XML data from your database using FOR XMLExposing XML documents as relational resultsets using OPENXMLUsing XDR and XSD schemas to retrieve results through HTTP requestsDescribing SQL Server tables using XML Views A detailed discussion of the use of XPath queries with SQL ServerModifying your database with UpdategramsImporting XML documents into your database with XML Bulk LoadAn overview of the new features provided with Beta 1 of Web Release 2Topics covered: The XML capabilities of Microsoft SQL Server 2000, including the FOR XML clauses in TransactSQL, the OpenXML specification, XDR and XSD schemas, templates, views, and updategrams.This book has been selected by the editors of Wrox Press to be part of the Wroxbase website. This book is for experienced SQL Server developers who are looking to make the data in their SQL Server 2000 databases available in XML and take advantage of the exciting new XML features in the recent Web Releases.
|
| |
|