+1 🙁

I believe we've had a similar question recently. Probably a similar discussion too...

L' Eomot Inversé (11/16/2012)

---

seankyleprice (11/16/2012)

---

Best Practice for 2008 onwards is surely to use TRY CATCH as suggested by Stewart. For 2005 and prior I agree that the method suggested by...

I've never actually used the keyword DEFAULT before...seems kind of redundant. Oh well, I manage to apply logic to the other possible answers and derive that it must be...

I agree this was a fun one. This operator was new to me...had to break out the notepad after searching through BOL. A nice refresher from the college days...Good...

I guess #4 only because it was a long winded answer. After trying to run the options, I have to agree that #2 should not be a valid answer until...

I think the question was poorly worded and intentionally misleads the reader. 😛

Just didn't seem like a QotD without some whining about the question.

Cheers for something easy on a Monday! :satisfied:

Yup, should have looked at this in the A.M. As soon as I saw the answers I was like "duh!" :blink:

I was dumbfounded after the correct answer was not listed: 11. The question clearly states "How many 8-bit characters are there between '0' and 'Z' (inclusive) in the...

I stumbled across Freedman's explanation in my search on the subject and was thrown by the options as well. Either way, I selected the UPDATE choice as the most likely...

One good thing about this question, I learned about a new feature in 2012. I missed the question, like most, because I made an assumption that the author made a...

After I pulled the pencil from my eye and reformatted the question...easy to spot. :w00t:

Seems like a nearly useless function, but at least I know about it now. It seems amazing to me that they can put this stuff in but leave out common...

Excellent question. This took some time to research because I rarely use table variables.