Writing Stored Procedures for Microsoft SQL Server

Using XML with SQL Server and Internet Information Server's Server Extensions

The Microsoft SQL Server XML technology preview demonstrates XML capabilities when combining the power of SQL Server's T-SQL and Internet Information Server (IIS) via the HTTP protocol. It is an IIS ISAPI extension that provides HTTP access to SQL Server using XML's data formatting and updating capabilities.

With the appropriate configuration, it allows URL queries like:

HTTP://IISServer/DBVirtualDir?sql=SELECT+*+FROM+Customers+FOR+XML+AUTO

It also allows you to store queries (including stored procedure calls) on the IIS server that can be executed from the URL or posted from an HTML form.

The XML SQL technology preview introduces a number of new features to support ...