listing of syntactically possible SQL statements

#1

I need such a list in order to check a parser to a utility to be used
with PreparedStatements

thanks
lbrtchx

#2

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

#3

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

#4

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

#5

On May 9, 10:27 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.

As for your other query, you might find some interest in Mimers sql-
validator:

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

/Lennart

#6

On May 9, 10:27 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.

As for your other query, you might find some interest in Mimers sql-
validator:

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

/Lennart

#7

On May 9, 10:27 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.

As for your other query, you might find some interest in Mimers sql-
validator:

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

/Lennart

#8

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?

Quote:

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. Now that I talk about it, are there
sample data sets that could be imported as csv into a DB and run tests
included stress tests?

lbrtchx

#9

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?

Quote:

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. Now that I talk about it, are there
sample data sets that could be imported as csv into a DB and run tests
included stress tests?

lbrtchx

#10

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?

Quote:

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. Now that I talk about it, are there
sample data sets that could be imported as csv into a DB and run tests
included stress tests?

lbrtchx