@foobar2005 said:
I want to say 'First!', but then I'd be like those other loosers
spelling loser "looser" makes you a loser, loser
@foobar2005 said:
I want to say 'First!', but then I'd be like those other loosers
spelling loser "looser" makes you a loser, loser
oh, crap. Now I get it. Yes, creating them as actual SQL user accounts is definitely "brillant"
your conversation doesn't even make sense, I fear for the users of your code
I don't know if this counts as a tri-bool, an infinite bool, or what. I found this on a sql forum. This guy was going nuts trying to figure this one out, and now I am too, so I figured I would share the insanity. If you have sql server try this:
-- Creates simple temp table
CREATE TABLE #foo (
IID int not null
)
-- insert to that table
INSERT INTO #foo VALUES (1)
-- Now run the following
SELECT * FROM
#foo,
(SELECT IID FROM #foo WHERE IID = 1) d1,
(SELECT IID FROM #foo WHERE IID = 1) d2
WHERE 1 = 1
As you would expect you get 1 row with 3 values 1, 1, 1
-- Now run this
SELECT * FROM
#foo,
(SELECT IID FROM #foo WHERE IID = 1) D1,
(SELECT IID FROM #foo WHERE IID = 1) D2
WHERE
(SELECT COUNT(IID) FROM #foo WHERE IID = 1) = 0
As you would expect you get no rows. We know that the count of #foo.IID where IID = 1 is 1. 1 <> 0 so no rows.
-- Just to prove the point
SELECT * FROM
#foo,
(SELECT IID FROM #foo WHERE IID = 1) D1,
(SELECT IID FROM #foo WHERE IID = 1) D2
WHERE
(SELECT COUNT(IID) FROM #foo WHERE IID = 1) = 1
Returns 1 row as you would expect.
-- Now run this
SELECT * FROM
#foo,
(SELECT IID FROM #foo WHERE IID = 1) D1,
(SELECT IID FROM #foo WHERE IID = 1) D2
WHERE
(SELECT COUNT(IID) FROM #foo WHERE IID = D1.IID) =0
This should return 0 rows but it returns one row
Now here's the insanity part. Change that last =0 to =1 and it still evaluates to true. Change it to whatever you want ( <-1, is null, is not null) and it evaluates to true. Hell ,I even cast the left side of the equality as a varchar and compared it to 'bob' and it still evaluates to true
2. The default speed of the slideshow is only 6 seconds per slide, but some of the slides have a full paragraph of text underneath. I've been told that I am a slow reader, so this may only be a problem for me, but it's annoying none the less
I am a pretty fast reader and that is still way too fast.