Jamie Longstreet-481950 (7/18/2010)

---

Textfield is the field name... are we not saying the same thing? The textfield is not the same for both the variable and the temp test table....

Both 1 and 4 could be the correct answer as Green, Orange and Purple do not actually contain a "R", so if you have a case sensitive collation you would...

I figured you were testing short-term recall to see if people still remembered what they learned. 😉

john.arnott (7/15/2010)

---

Yep, that is one of the things I...

Nice question, took a little looking at it to figure out what was going on. Thanks!

Interesting question, but it seems like it was more of a trick question than anything... The questions says "management wants to change the loginname so that it can accept longer...

WayneS (7/14/2010)

---

I have to admit that I got this correct, but for the wrong reason. In looking at the question

Using the default Northwind database on a default install of...

I too missed it because I didn't notice the ;. I know that you can't put it there but didn't see it. I don't know if I would have noticed...

Good question, and brings up something I haven't run into before. Thanks!

Thanks for the good question showcasing newer features!

Nice question, thanks! It is nice to see some of the SSMS features included in the QotD since people don't always explore and find them.

Nice question, thanks!

I'm a little surprised that so many people have gotten it correct so far, but that may be because of the copy, paste, F5 syndrome. 😉

I had to go do a little research before I answered this one, so I learned a little more about isolation levels, thanks!

Nice questions thanks! Yet more reasons to not use ISNUMERIC for most things.

Nice brain teaser of a question. Wow!

Though aren't the "None" and "0" choices the same? (I assume that 0 rows is no rows.)

Did it really need to be that complicated?...