This example-packed book can let you get more productive with the latest generation of SQL Server tools. After a brief 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 is to jump right in with tutorials on using XML in Microsoft Transact -SQL (T-SQL) supported in SQL Server. The author provides information on nuts-and-bolts to query the database and return 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 in this API. An important part in T-SQL OpenXML function shows how to perform various database tasks, including inserting XML data in bulk into database tables. In the closing sections, this text illustrates key technologies using both functional online computer store complete with shopping cart, product catalog, and simulated order processing, all using XML techniques demonstrated earlier on. Overall, this book provides solid tour of what's available in SQL Server, ADO, and other Microsoft tools and technologies Dragan. - Richard Topics covered: Overview's XML today for business use with the technology, Microsoft's database (integration with XML, B2B, B2C, and scenario B2E) Transact-SQL (T-SQL) support for XML in SQL Server (SELECT FOR XML, RAW, AUTO , and explicit mode) ActiveX Data Objects (ADO) support for XML (XML query templates, executing the query XML) SQLOLEDB XML properties (including style sheets and managing the output format) web publishing with SQL (SQL Server HTTP publishing overview Server, database publishing, virtual directories and IIS, URL queries, plus style sheets and stored procedures), XML templates for retrieving data via the Web (templates and template parameters, style sheets, posting templates) XML schema mapping (mapping scheme used by ADO and over HTTP, advanced notation ) Using OpenXML to accept and incorporate XML documents (overflow data and edge tables) XML to SQL Server 2000 Web Release (using Updategrams to insert, query, update, and delete XML data) case studies for online computer store using SQL Server and XML ( including catalog and shopping cart management, connection to the BizTalk Server 2000) Appendix for basic XML tutorial