Nice QotD. The '41' was a big clue. Thanks and keep them coming.

L' Eomot Inversé (10/28/2013)

---

No - the transaction is still open, and the table is not dropped until the transaction...

Didn't know the answer. But, FALSE seemed a reasonable guess, as that's what I would expect. Hard to see why they would recommend using specific user accounts.

doug.davidson (10/24/2013)

---

Good to know of the function exists but I still find it more useful to subtract, as this function only returns date; not date and time. I program in...

Koen Verbeeck (10/23/2013)

---

Easiest question ever. It doesn't even matter which feature is being asked.

Enterprise has every feature, and developer & evaluation have the same features as Enterprise.

Ergo, no thinking needed,...

Not easy for me, as I had to learn something first. So, it was the very best of QotD = learn something AND get points. 😉

Nice question. I think it's a more interesting question if you try this select:

SELECT 1

FROM TEST

or even this select:

SELECT [1]

...

Posting a bit late to the party, as Thursday was a hectic day. Thanks for this very interesting question. I figured there was a command option to force the defaults...

Thanks for the question Umer. It was nicely chosen and presented. Please post more.

Kanu, thanks for the question. While basic, it was interesting. Let's see some more.

L' Eomot Inversé (10/9/2013)

---

Nice question.

I've never understood why try...catch was banned in functions, but the explanation for this question provides a clue. I'd never seen the error messages, and...

Excellent! So good to see a very brief question with quite a few basic concepts packed into it. I got it right only because I realized that the literal string...

Thanks to OP for submitting the question. Still scratching my head about it being worth two points. But, I'll take them.

They put me that much closer to having enough...

Plus, now we have to deal with category inflation! 😉 When you click on the category, you...

Nice question - Monday easy, but still interesting.

Back from two week vacation in Greece --> back to work --> back to SQLServerCentral - the "back to SQLServerCentral" is the only...