Product Description

The rich XML support in SQL Server™ 2000 makes it easy to map relational data to XML. Discover how to use SQL Server and XML to move your critical business processes to the Web with the expanded 2nd edition of this popular title for solution developers. You’ll learn how to retrieve XML data from a database, insert XML data into the database, and manipulate it in extensible database solutions, using familiar standards such as XPath, XDR schemas, XSL Transformation, HTTP, OLE DB, plus newer tools. You’ll also find up-to-date coverage of the Simple Object Access Protocol (SOAP), the Microsoft® .NET Framework, SQLXML 3.0, XML Web services, Updategrams, client-side XML processing, and other vital topics. Topics covered include: • SQL, XML, and the business Internet • Retrieving XML data with Transact-SQL • Inserting XML data with the OpenXML function • Publishing databases with Internet Information Services • Using XML templates to retrieve data over HTTP • Using ADO for XML data access NEW TOPICS IN THIS EDITION INCLUDE: • Accessing XML data from .NET applications • Client-side XML processing • Modifying data with Updategrams • Modifying data with Diffgrams • Accessing data using SOAP INCLUDES SAMPLE CODE ON THE WEB! • Code samples available at the Companion Content link on this page

Product Details

• Amazon Sales Rank: #941450 in Books
• Published on: 2002-06-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 448 pages

Amazon.co.uk Review
For any developer who wants to do more with XML and databases on Windows, Programming Microsoft SQL Server 2000 with XML provides an up-to-date guide to some current XML tools and features available on the Microsoft platform. This example-packed book can let you get more productive with the latest generation of SQL Server tools.

After a quick tour of what XML means for business today, this text jumps right in with a tutorial on using XML in Microsoft Transact-SQL (T-SQL) supported in SQL Server. The author provides nuts-and-bolts information on querying databases and returning XML, along with different options for formatting XML data.

Next comes a tutorial for using ActiveX Data Objects (ADO), the preferred standard for programming with databases in Windows, and how to use XML within this API. Short code excerpts will show you how to perform common programming tasks quickly. The support for XML in Microsoft doesn't stop there, of course, and the book next focuses in on support for Web publishing in SQL Server through XML. This powerful feature shows you how to define templates that can be used to query and update data via HTTP using URLs. Sections on mapping schemas show how XML can used to move data between different database schemas. An important section on the T-SQL OpenXML function to perform a range of database tasks, including inserting XML data in bulk into database tables.

In its closing sections, this text illustrates key technologies using a nicely functional online computer store complete with shopping basket, product catalogue, and simulated order processing all using XML techniques demonstrated earlier on.

In all, this book delivers a solid tour of what's available in SQL Server, ADO, and other Microsoft tools and technologies. Suitable for any Windows IT professional who works with databases, this title is a capable tutorial and guide to what's out there today with XML on the Microsoft platform. --Richard Dragan

About the Author
Graeme Malcolm is principal technologist for Content Master Ltd., and apart from the first edition of this title he has also written several Microsoft training courses and presented at numerous conferences. Graeme is being presented to us from Content Master, a rich source for Microsoft for developing sample solutions, white papers, and training materials for other groups.

Customer Reviews

Detailed and Concise
This is a great book for getting up to speed quickly on the new XML features of SQL Server 2000.

The pace is excellent for experienced SQL Server programmers or DBAs but would probably be a bit tough for a novice user (but it does make this very clear at the beginning of the book). It assumes that you are already familiar with programming SQL Server and have at least some XML knowledge.

One or two areas are glossed over a bit, such as no mention of the XML View Mapper and there could be more details on using XPath but other than that this book is highly recommended.