Lynn Pettis (7/12/2012)

---

Although I got it correct, I think the true correct answer should have been Operating System Maximium. This would have taken the version of the OS out...

Hugo Kornelis (7/11/2012)

---

In my opinion, it is LEN() that has the strange behaviour here, because it returns the length of the padded version of the string instead of the length...

john.arnott (7/10/2012)

---

I nearly bit at the implication that SQL 2012 added syntax to allow truncating a table that met certain conditions. Had to find BOL 2012 online to disuade myself...

Haaico (7/4/2012)

---

It looks like the correct answer is incorrect :w00t: According to the explanation the correct answer is 10 but choosing that answer still results in "Sorry - you were...

Fun question.

[pedantry]

But "A cigar" is actually wrong, the right answrer is "two cigars" (because they have one each, they don't share one).

[/pedantry]

😀

Good question, nice and straightforward.

But I don't have a clue why someone decided that a computed column can not have its name changed, it strikes me as a unnecessary restriction....

Brandie Tarvin (7/25/2012)

---

Stefan Krzywicki (7/25/2012)

---

Brandie Tarvin (7/25/2012)

---

Taking a tangent...

I've blogged about this subject before, but didn't get much of a response other than a few laughs from people who thought...

Maybe it...

I though that was in laymans terms - after all, I was a mathematician, not a chemist, and mathematicians are...

Jason's C6H12O6 is a nasty ambiguous formula. ChrisW's thing is less ambiguous (but still ambiguous).

There's a nasty ambiguous word for it: hexose; but it's not quite as...

+1 more

tilew-948340 (7/20/2012)

---

davoscollective (7/17/2012)

---

Toreador (7/16/2012)

---

I was expecting to see a 100% correct rate given that the same thing has appear a lot in QOTDs over the last few months - but...

Duncan Pryde (7/3/2012)

---

Good question. Is this related to the behaviour of datetimes versus datetime2s with the british language setting?

SET LANGUAGE BRITISH

GO

DECLARE @datevar datetime2 = '2008-12-13'; -- no error, ymd format

SELECT...

Nice question.

But referencing an Sql 2005 BoL page seems a bit odd, as SQL 2005 is out of support (even though the same SP is still there now).

cfradenburg (6/25/2012)

---

I answered "true, false" because a table variable can only ever have on index. A primary key or (as I learned today) a unique clustered index. It's...