tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hooper, Brian" <brian.hoo...@lmco.com>
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
tip.

-----Original Message-----
From: Antonio Fiol BonnĂ­n [mailto:fiol.bonnin@terra.es] 
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message