Accompanied by a CD-ROM containing sample applications and code, an authoritative guide explores the functionality and capability of XML in SQL Server 2000 and shows how to construct extensible databases for B2B, e-commerce, and line-of-business applications. Original. (Intermediate)

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, whether in business to consumer (B2C), business to business (B2B), or business to enterprise (B2E) scenarios, 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 be used to move data between different database schemas. An important section on the T-SQL OpenXML function shows how 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 catalog, 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

Topics covered:

Overview of today's XML for business used with Microsoft database technologies (integration with XML, B2B, B2C, and B2E scenarios)
Transact-SQL (T-SQL) support for XML in SQL Server (SELECT FOR XML, RAW, AUTO, and EXPLICIT modes)
ActiveX Data Objects (ADO) support for XML (XML query templates, executing XML queries)
SQLOLEDB XML properties (including style sheets and managing the output format)
Web publishing with SQL Server (SQL Server HTTP publishing overview, publishing a database, virtual directories and IIS, URL queries, plus style sheets and stored procedures)
XML templates for retrieving data over the Web (templates and parameterized templates, style sheets, posting templates)
XML mapping schemas (mapping schemas used with ADO and over HTTP, advanced notations)
Using OpenXML for receiving and inserting XML documents (overflow data and edge tables)
XML for SQL Server 2000 Web Release (using Updategrams to insert, query, update, and delete XML data)
Case study for an online computer store using SQL Server and XML (including catalog and shopping basket management, connecting to BizTalk Server 2000)
Appendix for a basic XML tutorial

"About this title" may belong to another edition of this title.

Store Description

With 3 stores less than 1 hour outside the DC/Metropolitan area (1 in Gaithersburg, 1 in Frederick and 1 in Hagerstown, MD), we have the largest selection of books in the tri-state area. Wonder Book and Video has been in business since 1980 and online since 1997. We have over 1 Million books for sale on our website and another 1 Million books for sale in our 3 locations. Items on Abe are not necessarily in stock at our retail locations. Please do not call the stores to place orders for Abe Books sales. We have a very active online inventory and as such, we can receive multiple orders for the same item. We fill those orders on a first come first serve basis, but will refund promptly any items that are out of stock. Since 1980 it has always been about the books. ALL kinds of books from 95 cent children's paperbacks to five figure rare and collectibles. A merging of the old and new is where we started, and it is where we are today. Our retail stores have always been places where a reader can rush in looking for a title needed for a term paper that is due the next day, or where bibliophiles can get lost "in the stacks" for as long as they wish. In 2002 USAToday recognized us as "1 of 10 Great Old Bookstores", and we have been featured in numerous other newspaper and TV stories including Washington Post and CSpan. Members ABAA, ILAB.

Visit Seller's Storefront

Association Member

Members of these associations are committed to maintaining the highest standards. They vouch for the authenticity of all items offered for sale. They provide expert and detailed descriptions, disclose all significant defects and/or restorations, provide clear and accurate pricing, and operate with fairness and honesty during the purchase experience.

Seller's business information

Wonder Book
Wonder Book and Video, 1550 Tilco Drive, Frederick, MD, 21704, U.S.A.

Sale & Shipping Terms

Terms of Sale

We want you to be satisfied with the book you order. Our general description is conservative and the book should be as good or better than our general description may indicate.

RETURNS are cheerfully accepted up to 30 days. We ship out within 1-2 business days and U.S. Standard Shipments usually arrive within 6-9 business days, Priority 3-6. We want you to be satisfied with the book you order. Our general description is conservative and the book should be as good or better than our general descr...

More Information

Shipping Terms

STANDARD DOMESTIC U.S. SHIPPING IS FREE. Priority Shipping is only $6.99 for first item, $1 each additional. Orders ship within 2 business days. Shipping outside of U.S. is typically between $8-13 and takes between 8-15 business days. Heavier books may require additional shipping. Faster Needs Please Inquire.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	5 to 9 business days	3 to 6 business days
First item	US$ 0.00	US$ 10.98

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.