I only ever use the += with single values on the right-hand side, so I haven't encountered this. Seems like if you have an expression on the right, you should...

Deuce

Me, too. I read it half a dozen times to make sure I...

It's strange to see more wrong answers than correct answers (at the time of this writing "3" is 45% of the responses; "4" is 51% of the responses). Coffee...

Toreador (6/3/2016)

---

I knew what was intended but the correct answer surely should be "No, Never".

The semi-colon is not required to begin the CTE; it is required to terminate the...

This one wasn't simple for me. It takes a keen eye and some focused thought to get it right. I failed.

Thanks for the good question.

I don't recall ever writing code that passes a literal value to SUM() before, so when I saw the literal, my brain translated it to a column reference. I...

I selected "3 rows", then just as I was about to submit my answer, I noticed the scrollbar. After scrolling down, I quickly changed my answer.

Apparently, I've had just...

So, if I understand this correctly (thanks to posts from crmitchell and bknight), VARBINARY works more like VARCHAR when it comes to comparing values.

I agree with bknight that this seems...

daniel.plocinik (5/6/2016)

---

Thank you Steve for an exciting finish to a dull week. All these responses... I can only imaging what would happen if the question was worth 7...

The audience is listening.

https://www.youtube.com/watch?v=2zsT3BobzIQ

😀

In my opinion, the sort results should be unpredictable because NULL is an unknown/unspecified value, which implies it cannot be sorted.

I'm not arguing that the answer is incorrect. Practically,...

I initially selected the "four" option. Then the coffee kicked in. Whew!

Sorry for the premature post, everyone.

I just found this on Microsoft's site.

"If you use the MDSModelDeploy tool to update an existing model and its data, and the package...