O'Reilly logo

Writing Stored Procedures for Microsoft SQL Server by Matthew Shepker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required