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!!!!

Have good luck...

Explanation is in the note.

Try to reduce the precision.

SELECT CAST(cast(1.67574 as decimal(38,10)) / cast(10000 as decimal(38,10)) AS DECIMAL(38,10) ) conv_factor

returns 0.0001670000

SELECT CAST(cast(1.67574 as decimal(29,10)) / cast(10000 as decimal(29,10)) AS...