tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antonio Fiol BonnĂ­n <fiol.bon...@terra.es>
Subject Re: Microsoft SQL Server validation query
Date Fri, 09 Jan 2004 17:02:47 GMT
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

Mime
View raw message