Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XML
|
XML General XML discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XML section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 11th, 2003, 11:38 AM
Registered User
 
Join Date: Jun 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default XML schema for SQL

Does anyone know where I can find an XML schema for SQL 92 or SQL 99 standard?
I am not sure whether it is possible to define such XML schema or not, and I would appreciate any comments on this issue.
Thanks.
 
Old June 12th, 2003, 04:54 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

But an XML schema defines the structure etc of an XML document. Since SQL-92 and -99 are not XML documents, it doesn't make sense to have an XML schema for them.

that's my $0.02
Phil
 
Old June 12th, 2003, 09:19 AM
Registered User
 
Join Date: Jun 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

We can consider an SQL query as an XML document. For example:
<select>
  <elem>first_name</elem>
  <elem>last_name</elem>
</select>
</from>
  <elem>person</elem>
</from>

Since there is a somewhat defined structure of SQL queries, there should be a way to represent it as a DTD or XML schema and validate against either of them.
Maybe I am totally misunderstanding something here. Any hints?
Thanks.
 
Old July 29th, 2005, 05:40 PM
Registered User
 
Join Date: Jul 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

swan-

did you ever find anything like an XML schema/DTD or just a great format for representing SQL?

thanks

don

 
Old July 27th, 2006, 05:07 AM
Registered User
 
Join Date: Jul 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

apparently no such DTD exists as of yet... having searched wide and far (well, ten minutes) the only place mentioning a similar thought was
http://www.suehappycowboy.org/blog/?p=10






Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating an XML Schema johnnycorpse ASP.NET 1.0 and 1.1 Professional 0 April 5th, 2007 11:18 AM
Validating XML Schema lmadhavi XML 0 November 18th, 2004 06:58 AM
What's the use of XML Schema?! janise XML 2 August 29th, 2004 05:31 AM
xml schema help allang XML 0 August 19th, 2004 09:58 PM
XML, XML Schema, JavaScript, ASP cyberjames2003 XML 0 June 4th, 2003 04:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.