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.

The question is imprecisely worded. In the question does not mention that the bsmith user has rights to insert/update the table.

Last time it was there.

sknox Posted Today @ 1:22:41 PM

Good question, but the explanation is wrong on one point:

The MIN() and MAX() functions are aggregates, therefore the NULL is eliminated.

is not true.

The reason...

Into Your original code, I added some notes.

Select

pc.accountnbr 'account number',

qf.description...

Thanks Steve, that you teach us by small steps to learn about the Dynamic Data Masking. On 03/08/2016 it was about masking data type varchar. There was a reference...

Thank you for this interesting question. After TRUNCATE TABLE is the table empty. DBCC CHECKIDENT on an empty table returns null.

USE TestDB;

GO

CREATE TABLE Audit_Logins (ID INT IDENTITY, Name varchar(10));

SELECT *...