[xml-dev] XML representation of SQL queries?

["ken_north@compuserve.com" <ken_north@compuserve.com>]

Richard Tobin wrote
> Is there a standard way of representing SQL queries in XML?

There's a represention of SQL query *results* as XML that's been adapted
for different purposes. Java (JDBC) defines the format of a WebRowset
that's also supported by grid services and the Globus Toolkit.

Representing the SQL query source as XML would require an XML vocabulary
that can accommodate SQL as a moving target (different SQL dialects). Not
every SQL platform implements the SQL:2003 standard and platform providers
often implement extensions to the standard. 

The problem is somewhat analagous to trying to develop a standard XML spec
for office documents. One standard might support Java embedding, whereas
another might support embedded OLE components.





--------------------------------------------------------------------
mail2web.com - Microsoft® Exchange solutions from a leading provider -
http://link.mail2web.com/Business/Exchange