Starting from sql2000 sp4 and sql2005, sql2008, the optimizer changed strategy to retrieve data when you specify parameters in the where clause. So, in this case "column1 between @from and...

I full agree.

Thank you! I love undocumented. I learned something new! 🙂

if one table has one o more rows and the other is void, the result is 0.

NumberOfRows * 0 = 0

Please do not post useless thinks.

The main problem is not the format of date (dmy or mdy or ymd) nor if monday is the first day of the week, but identify the day '2010-2-1' as...

This code is indipendent from datefirst:

Monday is 0 and Sunday is 6

SELECT cast(cast('20100215' as datetime) as int)%7

SELECT cast(cast('20100216' as datetime) as int)%7

SELECT cast(cast('20100217' as datetime) as int)%7

SELECT cast(cast('20100218' as datetime)...

create table XPCmdShellOutput (OutputLine varchar(1000), ID INT IDENTITY(1,1))

Please add an identity column, so you can have output lines in the correct order

This assert is wrong.

The correct answer is 0,1, but the two statement should be the first in...

Volumes of data returned from tables may vary (test or production database), so a well performing query may slow down or give an error.

FROM BOL:

Including an extremely large number...

My answer is correct, but it's luck!

The text of the question is incomprehensible and the explanation is more and more incomprehensible.

That...

The question is:

it is a BUG?

... or it is by design?

... or both: it is a BUG by design!

Try this:

DECLARE @v-2 char(10)

SET CONCAT_NULL_YIELDS_NULL ON

SELECT ISNULL('abcd'+@v,'1234567890')

RESULT: 1234567890

This behavior is all right!

Also a void string take 1 CHAR:

SET CONCAT_NULL_YIELDS_NULL ON

SELECT ISNULL('abcd'+''+null,'1234567890')

Result: 123456

vk-kirov, I agree with you. Question and answer is incomprehensible!!!!