I didn't see the dbo schema before OPENJSON.

So the answer is correct, but not the explanation.

The query fails not because of compaibility level, but because of dbo schema before OPENJSON.

SELECT...

To select all rows from CustomerLeft change join precedence by parentheses:

SELECT *
 FROM dbo.CustomerLeft AS cl
 LEFT JOIN (dbo.CustomerContact AS cc 
 INNER JOIN dbo.EmailDomain AS ed...

"All roads lead to Rome!" we say in Italy. It depends on your case.

For Memory optimized premium-series the maximum is 64.

Sorry folks, but the QoD submission some how went wrong.

This was the original explanation

TL;DR; Put a ISNULL around the SUM to ensure a numeric value is always provided, even...

I think that the question is bad worded! So, the sentence "The software using the outcome of the code would always expect a numeric value" should be "The software doesn't...

I use this feature a lot, see the following example:

declare @t table (i int identity primary key, name sysname)
declare @i int = 1
,@name sysname

insert into @t
select TOP(10)...

I get it right, but I admit that the question is a little confusing: the value of 4 is the 3rd bit (starting from position ZERO, 2 is the right...

I think that ROLLBACK doesn't return any message.

In my browsers (edge & firefox)

In the explanation, to be precise, I would change "where the first number is not a 9"

with "where the first char is not a 9"

Good catch!

It is Interesting that NULL never has a BaseType, also if you cast it to a defined type (e.g. INT).

SELECT *
,LEN(V.a)
,dataLENgth(V.a)
,SQL_VARIANT_PROPERTY(V.a, 'BaseType')
 FROM (VALUES
 (N'1')
,('2')
,('3')
,(NULL)
) AS...

Try this (adjust for your needs), then execute the output script:

set nocount on
select DISTINCT 'exec sp_helptext ' AS '--','[' + o.name + ']' AS [ ],CASE OBJECTPROPERTY(o.id,'ExecIsTriggerDisabled')...

What's the syntax for "LOAD CERTIFICATE"? I cannot find it on BOL.

I saw that CREATE CERTIFICATE or ALTER CERTIFICATE loads the certificate from a file.

*** sorry for the spoilers; but my comment didn't make sense to me without them ***

I debated with myself between "Zero records" and the more comprehensive "Returns distinct rows...