I got this right! I learned my lesson from the last time - after equivocating for a minute, wondering "the choice of 1 is too easy, maybe there's a trick"...

Yes, that happened to me, too.

- webrunner

tommyh (6/16/2010)

---

Well with 17% wrong answers i would say that some people think that there...

F1Droid (6/15/2010)

---

Aargh!! Again my initial reaction was "that's easy it's 5,2,2 as LEN ignores spaces"... and then "hmmm, but that's too easy, there must be a trick in there"... and...

sjimmo (6/11/2010)

---

Actually, the goal should be to read and think.

That being said,...

Ninja's_RGR'us (6/11/2010)

---

webrunner (6/11/2010)

---

cathy.baker (6/11/2010)

---

No matter if it's a bad question or a trick question. The answer is one. The question was "How many records are returned from the...

cathy.baker (6/11/2010)

---

No matter if it's a bad question or a trick question. The answer is one. The question was "How many records are returned from the last SELECT?"....

That is my conclusion exactly after getting the question wrong for the wrong reason - I thought that the first...

Wow, that question was excellent. It really threw me for a loop and taught me something about the HAVING clause that I never knew before.

Thanks,

webrunner

Tom Garth (6/1/2010)

---

I think I almost got it right - 🙂

This was a great question that made me do a little reading and learn something about a little understood part...

Ouch! Got that one wrong.

Great question.

Thanks,

webrunner

I had some trouble understanding the explanation of the correct answer at first. The explanation for the answer states, "SQL Server will use the maximum identity value + increment in...

Yes, Paul, thanks. I too got it wrong and...

vk-kirov (5/27/2010)

---

webrunner (5/27/2010)

---

The invalid object error is in there, but the SELECT statements agree with the SELECT statement results presented in the QOTD correct answer. What statement does the invalid...

Hugo Kornelis (5/27/2010)

---

da-zero (5/27/2010)

---

I do not fully understand.

The batch begins with:

SET IMPLICIT_TRANSACTIONS OFF

According to BOL, this means the following:

... SET IMPLICIT_TRANSACTIONS OFF statement, which returns the connection to autocommit mode....