listing of syntactically possible SQL statements

#11

let me clearly (and very obviously ;-)) state that I just need fake/
test data and I wonder if they use reference data as they use in other
branches of science/engineering

lbrtchx

#12

let me clearly (and very obviously ;-)) state that I just need fake/
test data and I wonder if they use reference data as they use in other
branches of science/engineering

lbrtchx

#13

let me clearly (and very obviously ;-)) state that I just need fake/
test data and I wonder if they use reference data as they use in other
branches of science/engineering

lbrtchx

#14

On May 10, 2:46 pm, lbrt... (AT) gmail (DOT) com wrote:

Quote:

Also, in which versions of SQL is the <> operator written as != ?

!= is not part of sql standard, it is a vendor extension.

So, does it mean that some vendors include it as some sort of
programming-like syntax sugar, but also have the standard "<>" for
non-equality?

http://developer.mimer.com/validator/index.htm

Thanks and I am also looking for a test set of actual queries to test
some query parser that I coded.

haven't tried myself, but you might find something useful at:

http://www.itl.nist.gov/div897/ctg/sql_form.htm

/Lennart

[...]

#15

On May 10, 2:46 pm, lbrt... (AT) gmail (DOT) com wrote:

Quote:

Also, in which versions of SQL is the <> operator written as != ?

!= is not part of sql standard, it is a vendor extension.

So, does it mean that some vendors include it as some sort of
programming-like syntax sugar, but also have the standard "<>" for
non-equality?

http://developer.mimer.com/validator/index.htm

Thanks and I am also looking for a test set of actual queries to test
some query parser that I coded.

haven't tried myself, but you might find something useful at:

http://www.itl.nist.gov/div897/ctg/sql_form.htm

/Lennart

[...]

#16

On May 10, 2:46 pm, lbrt... (AT) gmail (DOT) com wrote:

Quote:

Also, in which versions of SQL is the <> operator written as != ?

!= is not part of sql standard, it is a vendor extension.

So, does it mean that some vendors include it as some sort of
programming-like syntax sugar, but also have the standard "<>" for
non-equality?

http://developer.mimer.com/validator/index.htm

Thanks and I am also looking for a test set of actual queries to test
some query parser that I coded.

haven't tried myself, but you might find something useful at:

http://www.itl.nist.gov/div897/ctg/sql_form.htm

/Lennart

[...]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

listing of syntactically possible SQL statements

comp.databases comp.databases

Re: listing of syntactically possible SQL statements - 05-10-2008 , 07:58 AM

Re: listing of syntactically possible SQL statements - 05-10-2008 , 07:58 AM

Re: listing of syntactically possible SQL statements - 05-10-2008 , 07:58 AM

Re: listing of syntactically possible SQL statements - 05-11-2008 , 10:17 AM

Re: listing of syntactically possible SQL statements - 05-11-2008 , 10:17 AM

Re: listing of syntactically possible SQL statements - 05-11-2008 , 10:17 AM