I am sorry. Note above I wanted send to Mr. tripleAxe.

You got it right!

With the words of the poet Shakespeare: Much Ado About Nothing. Steve has done a little typo only.

The result is always 65, even if you run eg....

I'm surprised that in the BOL is stated: "Dates cannot be specified; therefore, the date part of the datetime value is not allowed." But the following script can be used...

Thanks for this question. Perhaps even note that the vardecimal storage format is deprecated

and sp_estimated_rowsize_reduction_for_vardecimal is available in SQL Server Enterprise Edition only.

Thanks for this question Steve. Today I had to do with the question of a hard time, really dangerous.:-) Eventually helped me this article, which confirms that it is dangerous:...

Thanks Steve, it is striking that a high number of incorrect answers . Exactly the same question there was already March 21, 2016 and an article of the Stairway Series:...

Thanks for the interesting question. If you should really cover all the events on any table, it would be appropriate to use DDL_TABLE_VIEW_EVENTS.

New and interesting , thanks for this question Steve.

Thanks Horia, interesting question and good explanation. It may be useful when dealing with NULLs.

+1, Thanks Steve.

Ed Wagner (3/31/2016)

George Vobr (3/31/2016)

Toreador (3/31/2016)

I would have expected 'NULL' to be treated...

Toreador (3/31/2016)

I would have expected 'NULL' to be treated as a string with...

Hi Toreador

It just shows that the result with the NULL is the same as 'NULL', nothing more.

Sincerely...

Thanks Steve for an interesting question. I have tried a variant, the result of which I couldn't answer without running the code in SSMS. Try this:

SELECT TRY_CONVERT(XML, NULL);

SELECT TRY_CONVERT(XML, 'NULL');

SELECT...

Thanks for a good explanation and an interesting reference link.