[xml-dev] XML representation of SQL queries?

From
[email protected] <>
To
Date
2009-02-09T23:58:36Z
ID
<>
Thread
[xml-dev] XML representation of SQL queries?
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