Programming Microsoft SQL Server 2000 with XML, Second Edition
Programming Microsoft SQL Server 2000 with XML, Second Edition
Editorial Reviews
Amazon.com
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
--This text refers to an out of print or unavailable edition of this title.
Book Description
...shows developers how to use existing standards such as HTTP and Xpath to retrieve data in XML format and insert XML data into SQL Server-based relational databases
Programming Microsoft SQL Server 2000 with XML, Second Edition
Programming Microsoft SQL Server 2000 with XML, Second Edition,Graeme Malcolm,Microsoft Press,0735617740,Client/server computing,Computer Books: General,Computer Networks,Computer Programming Languages,Computers,Computers - Languages / Programming,Database Management - General,Database Management - SQL Server,Programming - General,Programming Languages - HTML,Programming Languages - SQL,Programming Languages - XML,SQL server,Computers / Data Transmission Systems / Electronic Mail
Hot Books:
- Programming Microsoft Visual Basic .NET for Microsoft Access Databases
- Programming Spiders, Bots, and Aggregators in Java
- Programming the World Wide Web (3rd Edition)
- Programming Visual C++
- Programming Web Services with Perl
- Pro Jakarta Velocity: From Professional to Expert
- Rapid Contextual Design, First Edition : A How-to Guide to Key Techniques for User-Centered Design (The Morgan Kaufmann Series in Interactive Technologies)
- Sams Teach Yourself Microsoft Access 2000 in 10 Minutes
- Sams Teach Yourself Microsoft Office Access 2003 in 24 Hours
- SAS for Forecasting Time Series, Second Edition
Hot Books
Recommended Books
- Interpreting Art : Reflecting, Wondering, and Responding
- The Classified Cat
- Book of Alien
- British Television Drama in the 1980s
- Being Apart from Reasons : The Role of Reasons in Public and Private Moral Decision-Making
- Atomic and Molecular Data and their Applications : 3rd International Conference on Atomic and Molecu
- Borehole Flow Modeling in Horizontal, Deviated, and Vertical Wells
- An introduction to relativistic processes and the standard model of electroweak interactions
- Annie's Song
- Business, Religion, & Spirituality: A New Synthesis
- BLACK CAT MADE ME BUY IT
- Clement Marot: A Renaissance Poet Discovers the Gospel : Lutheranism, Fabrism and Calvinism in the R
- BATTLE OF TRAFALGAR
- An Introduction to Tropical Rain Forests
- Diving & Snorkeling Red Sea