Résumé
- An introduction to XML
- How to retrieve XML data from your database using FOR XML
- Exposing XML documents as relational resultsets using OPENXML
- Using XDR and XSD schemas to retrieve results through HTTP requests
- Describing SQL Server tables using XML Views
- A detailed discussion of the use of XPath queries with SQL Server
- Modifying your database with Updategrams
- Importing XML documents into your database with XML Bulk Load
- An overview of the new features provided with Beta 1 of Web Release 2
Book overview
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.
Who is this book for?
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.
Table of Contents
- Chapter 1: An Introduction to XML
- Chapter 2: Overview of XML in SQL Server
- Chapter 3: FOR XML
- Chapter 4: OPENXML
- Chapter 5: XDR Schemas
- Chapter 6: XSD Schemas
- Chapter 7: XML Templates and Views
- Chapter 8: XPath
- Chapter 9: Updategrams
- Chapter 10: XML Bulk Load
- Case Study 1: Enhancing Legacy Applications with XML
- Case Study 2: An Order Entry System Using VB and XML
- Case Study 3: Creating an XML Reporting System
- Case Study 4: SOAP
- Case Study 5: A .NET Case Study
- Appendix A: Creating and Configuring Virtual Directories
- Appendix B: Microsoft XML View Mapper 1.0
- Appendix C: Web Release 2 - Beta 1
L'auteur - Wrox Team
Michael Brundage, Patrick Dengler, Jeff gabriel, Andy Hoskinson, Michael Kay, Thomas Maxwell, Marcelo Ochoa, Johnny Papa, Mohan Vanmane, John Carnell, Bjarki Holm, Ann Horton, Kevin Mukhar, Daniel O'Connor, Mario Zucca, Michael Awai, Matthew Bortniker, Jaeda goodman, Thomas Kyte, Glenn E. Mitchell II, Gary Nicol, Frank Hubeny, Sean Dillon, Drew Erwin, Guy Ruth-Hammond, Burton Harvey, Simon Robinson, Julia Templeman, Karli Watson, Subrahmanyam Allamaraju, Ronald Ashri, Chad darby, Robert Flenner, Tracy Karsjens, Mark Kerzner, Alex Krotov, Alex Linde, Jim MacIntosh, James McGorven, Thor Mirchandani, Bryan Plaster, Don Reamy, Dr P G Sarang, Dave Writz, Aldo Calpini, Arthur Corliss, Simon Cozens, JJ Merelo-Guervos, Aalhad Saraf, Chris Nandor...
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Wrox Press |
Auteur(s) | Wrox Team |
Parution | 01/06/2001 |
Nb. de pages | 596 |
Format | 18,5 x 23,2 |
Couverture | Broché |
Poids | 1039g |
Intérieur | Noir et Blanc |
EAN13 | 9781861005465 |
ISBN13 | 978-1-861005-46-5 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
- Informatique Bases de données Produits SGBD SQL Server
- Informatique Développement d'applications Conception et développement web
- Informatique Développement d'applications Conception et développement web Services Web
- Informatique Développement d'applications Langages HTML
- Informatique Développement d'applications Langages XML
- Informatique Développement d'applications Langages XSLT
- Informatique Développement d'applications Langages ASP.NET
- Informatique Certifications Microsoft