Beginning SQL Server 2000 for Visual Basic Developers

This manuscript is an abridged version of a chapter from the Wrox Press book Beginning SQL Server 2000 for Visual Basic Developers. This chapter explores new XML features in SQL Server 2000 and takes a look at how you can exploit them to your benefit. We will also take a look at how we can use XSL (Extensible Stylesheet Language) to format and display XML data.

This book covers all you need to know to work with SQL Server 2000, to provide users of your VB and web-based applications with controlled access to your data. Starting with an introduction to designing and creating a database and working through creating increasingly complex T-SQL stored procedures, you'll learn how to incorporate data access (including ADO) into your VB applications, manage security, and make data available across the Web. For further details about the book, and other books in our range, visit the Wrox Press Web Site.

• Introduction and XML Overview
• Selecting XML Data
• XSL Stylesheets
• Calling Stored Procedures in URL's
• XML Templates
• Annotated XDR Schemas and Summary

©1999 Wrox Press Ltd.