- Shopping Bag ( 0 items )
From Barnes & NobleThe Barnes & Noble Review
SQL 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