Guessed wrongly that it was zero-based.

I've never used this function and have no intention of starting - it does nothing that cannot already be achieved by other means.

Does anyone know...

A good question, but the explanation isn't very helpful

:Whistling:

"however, you have to append in increments with each increment less than or equal to 4000"

Not true.

declare @test-2 nvarchar(max) = ''

select @test-2 = @test-2...

Didn't even notice the position outside the While loop. The fact that the variable is set to 1 on the previous line means that even if it were within the...

Yes, I do, especially given that the forum is free. In this case, the mistake...

Hardly an abject failure, he just got one word wrong.

Though I was looking for a "none of the above" answer to "which of these queries will do this", because no...

SQLRNNR (7/25/2015)

Well, if the view does not exist or is in a different schema, then the third option is correct even though it truncated part of the error. Up...

Because as I noted earlier on, the explanation is wrong is claiming that the difference in behaviour is between Set and Select....

The explanation says

When assigning from a query and the query returns no result, SET will assign a NULL value to the variable.

When assigning from a query and the query...

It was a choice between 2 answers (the third is clearly wrong), so random...

TomThomson (7/1/2015)

Well, English is one of my native languages and although I agree that the question could usefully have been worded differently (to make it easier for non-native speakers to...

Well English clearly isn't the poster's first language, but I'd have hoped the wording could have been changed by whoever approved the question! It was a bit of a guess...

https://msdn.microsoft.com/en-us/library/ms187786.aspx

The question is too vague. I'm sure there are reasons for choosing most of them.

For instance, I went for CURRENT_TIMESTAMP because it does not require (and indeed cannot have)...