Re: Celko: help with an experiment
From: Paulie <paul_at_not.a.chance.eircom.net>
Date: Sun, 07 Jul 2002 00:01:22 GMT
Message-ID: <3d2784ce.80958001_at_news1.eircom.net>
Date: Sun, 07 Jul 2002 00:01:22 GMT
Message-ID: <3d2784ce.80958001_at_news1.eircom.net>
71062.1056_at_compuserve.com (--CELKO--) wrote:
ThinkSQL www.thinksql.co.uk - an RDBMS engine that one can get with delphi...
W2000 Pro.
> > 1) SELECT * FROM Foobar;
> [X ] 1
> 2) SELECT MAX(i) FROM Foobar;
> [X ] 1
> 3) SELECT * FROM Foobar WHERE 1 = 0;
> [X ] Empty set
> 4) SELECT MAX(i) FROM Foobar WHERE 1 = 0;
> [X ] NULL
> 5) SELECT CASE WHEN 1 = 1
> THEN 99
> ELSE COUNT(*) END AS x
> FROM Foobar
> WHERE 1 = 0;
> [X ] 99
> 6) SELECT CASE WHEN 1 = 0
> THEN 99
> ELSE COUNT(*) END AS x
> FROM Foobar
> WHERE 1 = 0;
> [X ] 0
Paul...
> --CELKO--
Received on Sun Jul 07 2002 - 02:01:22 CEST