 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / April 2007How Does One Tell which Version of SQL One Has?
How does one tell which version of SQL one has? ---Kevin Simonson "You'll never get to heaven, or even to LA, if you don't believe there's a way." from _Why Not_ kvnsmnsn@hotmail.com wrote on 13.04.2007 17:41: > How does one tell which version of SQL one has? What do you mean "which version of SQL"? Are you referring to the different ANSI SQL Standards (SQL 89, SQL 92, ...)? Thomas On Apr 13, 10:17 am, Thomas Kellerer <JUAXQOSZF...@spammotel.com> wrote: => How does one tell which version of SQL one has? = =What do you mean "which version of SQL"? = =Are you referring to the different ANSI SQL Standards (SQL 89, SQL 92, ...)? Yes. ---Kevin Simonson "You'll never get to heaven, or even to LA, if you don't believe there's a way." from _Why Not_ > On Apr 13, 10:17 am, Thomas Kellerer <JUAXQOSZF...@spammotel.com> > wrote: [quoted text clipped - 7 lines] > > Yes. You refer to the documentation for the database system you're using. It should tell you which standard the system supports. You could also test for the level of SQL 92 compliance programmatically using methods on the DatabaseMetaData class such as supportsANSI92EntryLevelSQL, supportsANSI92IntermediateSQL and supportsANSI92FullSQL. David Harper Cambridge, England Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.