Great question. You got me on this one. -1 point for me.

roger.plowman (11/28/2011)

---

You know, the fact this was a trick question highlights a glaring flaw in T/SQL (or perhaps SQL in general?). Using single quotes for both strings and dates is...

Don't you hate it when the explanation says, "Despite what BOL says..."

It should either be mentioned in BOL or do what the BOL says.

L' Eomot Inversé (11/22/2011)

---

SanDroid (11/21/2011)

---

I understood the percision, but since the QOTD script was a picture instead of text the last 9 looked like a zero for insert 2. ...

Okay, so I knew it rounds the milliseconds to .000, .003, or .007; however, I didn't know when it rounds up or down.

So, when the time ends in .001, what...

Chris Umbaugh (10/11/2011)

---

I also had never heard of EXCEPT and INTERSECT and learned a lot from this QOD. I even had an opportunity to employ INTERSECT in a QA query...

vk-kirov (10/10/2011)

Please be aware that the INTERSECT operand has higher precedence than the EXCEPT and UNION operands (http://msdn.microsoft.com/en-us/library/ms188055.aspx):

EXCEPT and INTERSECT (Transact-SQL)

Remarks

If EXCEPT or INTERSECT is used together with other operators...

Like other have already stated, this was a great straight-forward question. That's excellent and I congratulate the author for this one.

I also agree that 999 on a single table...

tommyh (10/3/2011)

---

There are several problems with this question. One being that you cant declare @Start 2 times.

The other being that the answer is wrong. They both perform equally. I have...

L' Eomot Inversé (10/1/2011)

---

Nice question.

I wondered what on earth it was about when I first looked at it. Then noticed the order, and remembered that "BETWEEN" is just another...

That's what caused me to miss it too.

Always makes me wonder what...

Toreador (9/26/2011)

---

Good question - shame there weren't more possible answers given, I only had to look at the first two, and would probably have got at least one of the...

Remove their permissions from the whole server. ...

You...

I got it right but for the wrong reason. The reason specified was for case sensitivity but I thought of other reasons it wouldn't run. The question said...