Alvin Ramard (9/14/2010)

---

WayneS (9/14/2010)

---

Chad Crawford (9/14/2010)

---

Alvin Ramard (9/14/2010)

---

Ah darn! I ran...

Hugo Kornelis (9/12/2010)

---

However, I did not just post without checking. Here is how I checked my statement about the data type returned by the ROUND function:

SELECT ROUND(5/3.0, 1, 2) AS...

I think there's a small error in the explanation here. Round never returns a result of type decimal(8,6) because every decimal result that it returns has precision 38 - the...

Really good fun question. Thanks Hugo.

I looked at it for a bit and concluded that if it didn't generate an error message then it should return the three groups...

Would a reference to https://secure.wikimedia.org/wikipedia/en/wiki/Microsoft_SQL_Server#Architecture be cruel?

Title: Colossus

Author: D.F.Jones

Published: May 1966. Hardback, ISBN 0-246-64345-5

UK Paperback 1968

Film Version: Colossus:...

Real lox or smoked?

mtillman-921105 (9/8/2010)

---

Logic divides arguments into subjects and predicates. A column is usually the subject in a table, and the value for each row the predicate. So, you have...

As...

mtillman-921105 (9/8/2010)

---

In the first post, it says that NULLs are, in effect, in logic and in algebra. But notice that we should be more careful about that since logic...

Now that I've seen that one, and the one which...

Flight

In just under 24 hours I will be somewhere over the west Atlantic on my way to my nice warm winter home.

Nice question.

It and the discussion illustrate a couple of the defects of (T-)SQL.

This was real fun. So was the subsequent discussion. I really ought to get back to looking at QOTD regularly as there seem to be some real gems...

good question. some good discussion too. but shifting from explicit conversion of datetime to int (fast and efficient) to explicit conversion of datetime to a very local varchar date...