When you run the follow script in SSMS, which of the outputs do you expect to be returned?
Surely all answers are right, unless chooses an unexpected answer? 😛
I was aware of the point the question was looking to make, but couldn't be bothered fighting through the text to prove it so picked one at random. I got it 'wrong'.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi