As XML applications mature and enter their second generation, application developers will leverage the built-in extensibility of XML more frequently, adding new data elements to existing XML formats that first-generation applications use. How well first-generation applications work with this additional data depends on whether the developer considered extensibility in the application's architecture. Luckily, SQL Server 2000 has built-in functionality to account for additional data, even when you don't know what or how much additional data you might need to receive or send from your application. Let's explore this functionality by way of an example.

SQL Server 2000 and XML for SQL Server 2000 Web releases (SQLXML) provide three ways in which you can store XML data. XML Bulk Load and Updategrams, two client-side technologies, use annotated schemas to specify the mapping between the contents of an XML document and the tables in your database. OpenXML is a server-side technology that lets you define a relational view on an XML document. With OpenXML's relational view, you can use T-SQL code to query the data in the XML document and store the results in your SQL Server database.

Well, welcome to XML for SQL Server 101. I'm Professor SQLXML, and for the remainder of this column, I am going to teach a survey of the XML features provided by SQL Server 2000. As with other survey classes, the point here is not to get into any great detail on any one topic, but to give you an idea of the XML features provided by SQL Server 2000, and how they can be used to solve some common application development problems and scenarios. At the end of the column, I will also discuss where you can get more information about the XML support provided by SQL Server 2000.

Learn how SQL Server's XML features can provide your databases with new functionality.

Front-end developers frequently want to add functionality to the presentation tier of an n-tier architecture, but such requests can require changes on all tiers just to get the data and present it. This process can be made easier and more flexible by using SQL Server stored procedures to automate the delivery of data in XML format from the database to the front-end components. In the component presented here, stored procedures are invoked by XML strings, XML is returned, converted using XSL, and presented to the client in HTML. The technique supports rapid changes yet doesn't sacrifice the n-tier approach. This approach can be used with either SQL Server 7.0 or SQL Server 2000.

How to optimize SQLXML performance for databases, including SQL Server 2000.

Introduces the SQLXML tier, a combination of XML-based communication to Microsoft SQL Server through an Internet Information Services (IIS) virtual directory.

How to use SQLXML Managed Classes for .NET code to retrieve XML from a Microsoft SQL Server database or to generate XML on the client side, using ad hoc queries, stored procedures, annotated schemas with XPath, or XML templates.

Web services support in Microsoft® SQLXML 3.0 exposes Microsoft SQL Server™ 2000 as a Web service that offers SQL Server functionality to the clients. You can send SOAP HTTP requests to a server that is running SQLXML 3.0 to execute stored procedures, user-defined functions (UDFs), and templates.

How to take advantage of features in SQL Server 2000 and Excel 2002 in order to distribute enterprise data to Excel 2002 via XML.

The latest technology buzz is Web services. Terms such as Simple Object Access Protocol (SOAP), Web Services Description Language (WSDL), and Universal Description, Discovery, and Integration (UDDI) now appear in almost all marketing materials about XML and the Internet. But how are Web services relevant to you as a SQL Server professional?

Learn about the guidelines for XML data modeling and usage in SQL Server "Yukon", and see illustrative examples. To get the most from this paper, you should have a basic understanding of XML features in the context of SQL Server.

Take a look at the bridges that SQLXML provides between SQL Server 2000 and the .NET Framework.

Sick of updating your MySQL database to add new fields half way through a project? In this article Bjorn discusses his PHP class that you can use to make changes to your MySQL database on the fly!

15 Second's XML section focuses on Server-side XML and XSL processing using ASP.

The RTM version of SQLXML 3.0 moves from attribute-centric to element-centric XML rowsets and returns DataSet objects from SQL Server 2000 stored procedures.

Create a component that queries and updates SQL Server 2000 using XML.

SQLXML allows you to send queries to your SQL Server database and to be able to retrieve the results in XML over the web. This article will tell you how to set it up.

Using SQLXML to display a report.This example is focused on using the SQL Server 2000 SQLXML functions in asp pages. We will get data from data base in xml format and using xsl we will display data in asp page.

In previous article, I have shown you how to set up SQLXML on your computer and a virtual directory to use. Now, I will show you how to use ASP.NET to access and retrieve SQLXML documents and there isn't much work to be done, it's all here. They've even given you a class library to use.