Overview
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 SOAPINCLUDES SAMPLE CODE ON THE WEB!
- Code samples available at the Companion Content link on this page
Synopsis
Extensible Markup Language (XML) is the lingua franca of business information exchange. And with "Programming Microsoft SQL Server 2000 With XML, " developers get the expert guidance they need to build powerful, XML-enabled database applications for lines of business, e-commerce, and the Web. All the book's code appears on the CD-ROM so readers can study and reuse them for their own projects.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewSQL Server 2000 has exceptionally strong support XML support. If you're ready to take advantage of that support to enterprise, e-commerce, or web apps, Graeme Malcolm's Programming Microsoft SQL Server with XML offers the insight and code you're looking for.
Malcolm -- well-known for his talks at xmldevcon and his online seminars for Microsoft -- starts by showing how to use Microsoft's new T-SQL extension SELECT...FOR XML to retrieve data in XML format. (It's a two-way street; later, Malcolm shows how to decompose XML documents for storage in rowsets using T-SQL's new OpenXML() function.)
You'll learn how to use ADO for XML data access, rendering the resulting XML fragment as a well-formed XML document). SQL Server 2000 supports the application of XSL style sheets on the server, so you can convert to HTML right then and there. Malcolm, of course, shows you how.
The book concludes with several real-world projects, ranging from knowledge management tools to B2B -- each supporting the fictional Northwind Traders food wholesaler. (Hey, this is a Microsoft Press book. It hadda be Northwind!) All the code's on the accompanying CD-ROM, along with a complete e-copy of the book.(Bill Camarda)
--Bill Camarda is a consultant, writer, and web/multimedia content developer with nearly 20 years' experience in helping technology companies deploy and market advanced products and services. He served for nearly ten years as vice president of a New Jersey-based marketing company, where he supervised a wide range of graphics and web design projects. His 15 books include Special Edition Using Word 2000