XML and MS SQL Server 7.0

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):

  1. XSL Transforms as Query Language
  2. Structured Writing, Structured Search
  3. PHP from XSLT
  4. XSLT Google Directory Category Hack
  5. Microsoft responds to the Halloween Letter

More like this: , , .