|
|
|
XML @ Web Programming
Programming Shed : Programmer Store & Resources |
|
|
|
|
|
XML Index - XML Book :
Programming Microsoft SQL Server 2000 With XML (Pro-Developer)
by Graeme Malcolm Paperback - 400 pages Book & Cd edition (June 2001) Microsoft Press ISBN: 0735613699 Dimensions (in inches): 0.90 x 9.21 x 7.42 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 Book Description: 25-Word Description This title gives developers the expert guidance they need to build powerful, XML-enabled database applications for line-of-business, e-commerce, and the Web. 75-Word Description Extensible Markup Language (XML) is the lingua franca of business information exchange. This book gives developers the expert guidance they need to build powerful, XML-enabled database applications for line-of-business, e-commerce, and the Web. The author steps through the development of several... Customer Reviews Reviewer: Elena Malnati from Varese, VA Italy I never expected so much useful information into such a small book. Good books don't sell by weight or page count. I found this book concise and clear (this man knows how to teach). It sure doesn't explain everything about the subject, but it gives the big picture, with an impressive number of details too. Ideal to start working in small time. NOTE about who is this book for: As title state, this book teaches how to use the XML features of SQL Server 2000, not how to use SQL2000, so if you don't know SQL Server you better read something else first. From the XML XSL XPath X... side, this book is also for novices as it has a very good appendix that teaches all you need to understand the book. Reviewer: zen_mind from Chicago, IL USA While the author does an OK job explaining the subject matter, I don't see why anyone should spend $60 on this tiny book when you can find other books that sell for the same price or less and cover XML and a lot more. Professional SQL Server 2000 Programming from Wrox has two very good chapters on XML in about 100 pages, and *1300* pages more covering just about everything else related to SQL Server, *all for the same price*. There are other books that concentrate on the XML part only and sell for $10-$15 less but I have not read them. And of course, there's always SQL Server Books Online, which is free if you already have SQL Server 2000 installed. If I pay first class fare, I expect the meal and the wine, not just the peanuts. Reviewer: Peter G Higgins from Atlanta, GA USA Although this book didn't go quite as in depth as I would have liked it to, it was well layed out and had a lot of practical examples. Everything in it was easy to follow and focused on making the technology work instead of delving into the techie jargon about the theory behind it. This book won't make you an expert, but will give you enough to be able to start plugging this stuff into your projects pretty quickly. Reviewer: Stuart Bloom from Earlville, IL USA There is little here beyond what is in the Microsoft documentation. And $60 for less than 300 pages? Even with the big price and the scanty page count, they still find it necessary to refer you to the CD to see the code. The Wrox press SQL Server XML book is much meatier, more up to date, and ten bucks less. |
|
|
|
© 2005-2006, Programming Shed
|
