At XML One, Microsoft gave a demo of the support for making queries via URL and getting back XML in the upcoming release of SQL Server. They are supporting ad-hoc queries like:
http://localhost/mydatabase?sql=SELECT+*+FROM+Customers+FOR+XML+AUTO
They are also supporting functionality similar to Oracle’s XSQL servlet through templates. The templates are similar to XSQL pages in that you specify a query in the XML, and link an XSLT stylesheet for formating the results.
Possibly Related posts (machine generated):