Oops, I didn't realize those types of queries don't fly on other databases. Thanks for the tip.
-----Original Message----- From: Antonio Fiol Bonnín [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 12:03 PM To: Tomcat Users List Subject: Re: Microsoft SQL Server validation query Hooper, Brian wrote: >These queries all seem like an awful lot of unnecessary processing. >Here's what I use: > >SELECT 1+1 > > Indeed. If your server supports it, there is an even simpler one: "select 1" or "select 0". But this is not correct SQL for an Oracle server. Equivalent Oracle syntax is "select 1 from dual". But on other servers, "dual" does not exist by default. Well... you see what I mean... Antonio --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]