Re: [xml-dev] XML representation of SQL queries?

[nico <ndebeiss@gmail.com>]

what about XQuery  : http://www.w3schools.com/xquery/default.asp ?
I never used any part of that, but I thought that was ok.

Nico

2009/2/10 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



_______________________________________________________________________

XML-DEV is a publicly archived, unmoderated list hosted by OASIS
to support XML implementation and development. To minimize
spam in the archives, you must subscribe before posting.

[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Or unsubscribe: xml-dev-unsubscribe@lists.xml.org
subscribe: xml-dev-subscribe@lists.xml.org
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php