[QMKevin]

I’m working with the ODBC drivers to get data, but I’m not sure what exact language I should be using to do more than the basics.

For example, I can’t use Oracle query comments, such as “ROWNUM”, but neither can I use SQL commands like NEWID()

Can anyone tell me what query language I should be looking at?
This is a cached copy. Click here to see the original post.

[mhuffman]

In general, you should be able to use SQL92 syntax.

An updated version of the driver expected for rollout in 2009 will address a few current shortcomings such as nested SELECT queries and the CASE statement.

[ivan.parra]

RE: What query language should I use?

try rownum()

[QMKevin]

Thanks for the replies, guys – Looking forward to the new release next year

[sohail malik]

RE: What query language should I use?

Any plan on the new release for 2009. The CASE statement sure would be handy right now.

[Author]

Posts