Nice one!

With this set of original data, it's not really doing much, since all the ID-s are different, so the inner SELECT will effectively yield the original table, and the...

Except you didn't really. Somehow you changed what I answered, from what is now the correct answer to the answer initially marked as correct.

I'm thinking both the answer and explanation got a bit lost in translation...

You can remove the TOP  or the WITH CHECK option. Either will do the trick, as well as removing both.

Disappointed!

The way this question is asked it would be 11 hours, but I do get the confusion: that's what happens when British people try to Americanize the question, LOL....

We wait until the...

17-7 = 10, and then some minutes. Given that billing is per started hour, I'd venture that the available answers fall short.

I'm not even going to begin trying to figure out what the question is. My guess is at least half the text is missing.

There are two results that can...

The correct answer to this will depend on the setting of ANSI_NULL_DFLT_ON, since the NULLability of the CHAR column isn't specified.

The question is asked clearly: "What is the limit for rows in a Table Valued Constructor?". The documentation states that there is a limit. So there is nothing left...

A table valued constructor is only limited to 1000 rows when used directly as a source for an insert statement. When used to create a derived table there is no...

Part of the QotD is knowing defaults. This was left off, as many people do this and the default is to allow NULLs.

As a good practice, however, I agree....

Just to nit-pick: This will depend on the settings of ANSI_NULL_DEFAULT_OFF / ANSI_NULL_DEFAULT_ON for the session, or by the ANSI_NULL_DEFAULT database option. By default, these will be set such that...