tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hooper, Brian" <>
Subject RE: Microsoft SQL Server validation query
Date Fri, 09 Jan 2004 17:52:02 GMT
Oops, I didn't realize those types of queries don't fly on other databases.  Thanks for the

-----Original Message-----
From: Antonio Fiol BonnĂ­n [] 
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:

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...


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message