Define a single var as char(2) with cr and lf in it, instead of chancing forgetting either when you put them in separate vars.

Question posters: Run your code and mention...

What is it with questions being wrong on this site?

SQL 2008 Developer Edition. I copied your code, pasted into my SSMS and this is the exact output:

What you see...

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

print 1

--...

I don't think there was an "it depends" answer. It seems the question is flawed to the point where you can't say that a single answer is always true, most...

I typed the code into my SSMS as I wasn't sure of the answer, and I definitely got the error complaining about the number of columns. I could be doing...