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 *...

Thanks for the interesting question Mohammad. Query result is better seen from this auxiliary script:

DECLARE @emp TABLE ( id INT );

INSERT INTO @emp VALUES ( 1 ),( 2 ),( NULL...

Thank you for your useful question and good explanation. A similar instructive example

is shown in this ref: https://msdn.microsoft.com/en-us/library/ms188048.aspx

Interesting question, thanks for excellent explanation and comprehensive reference.

An interesting question, which can be interpreted differently, thanks. It is quite unfortunate

that even this piece isn't critical to the puzzle https://support.microsoft.com/en-us/kb/926070

Thank you Uwe for this interesting question, very good explanation and the links.

I learned today something new.:-)

A really interesting question , thanks Umer . But just simple complicated? 😉

DECLARE

@max-2 AS NVARCHAR(MAX) = ''

, @Var AS VARCHAR(4000) = 'ABCabc123';-- Varchar instead Nvarchar --

SET @max-2 =...

Useful and interesting question, thank you Steve.

The same result for i may give also this script:

SELECT

MyID

, COUNT(*) OVER (PARTITION BY '') AS i

-- OVER (PARTITION BY '') is the same...