Question is about nvarchar. Correct answer to that question is 4, which I picked.

Purported answer is about nchar, which is different, and not simply a typo. Author of...

I have to disagree with one part of your "correct" answer set. You say that existing indexes can be used, and that cost me a point for this question.

Microsoft...

Ran this under SQL Server 2005 SP3 (9.0.4053) and got following results:

What you see...

-----------------------

print 1

-- Comment one print 2

-- Comment two

print 3

-- Comment three

print 4

is not what you get!

-----------------------

1

2

3

4

Interestingly, in...