The correct answer is "none of them".

The query below generates an error: "Ambiguous column name", because "val" is both an alias and a column name:

SELECT id, ISNULL(val, id) + 1...

I think that the DMK should be open before the backup.

If it's encrypted by SMK, sql server open it automatically else you must execute OPEN KEY.

The usual typo! @@servicename()

How am I supposed to know whether it's an accidental mistake or intentional?

The answer is correct:

"3 out of 10 rows affected"

Case sensitivity strikes again. ??

Does it return two result set? 🙂

In this case "GO" is the name of the column:

select @@version go

is the same as

select @@version AS go

or

select go = @@version

Maybe an error is generated if I use semicolon ";"

select...

Classic XSS "<asdasd>"!

Another interesting question with a wrong answer!

The correct answer is 'Neither' because the identity column can be reseeded; therefore, a continuous sequence is not guaranteed.

If I want to check that ONLY the CustomerContactFirstName and CustomerContactLastName are update, then the right command is

IF COLUMNS_UPDATED ()= 0x0C0000

If I want to check that the CustomerContactFirstName and CustomerContactLastName...

The answer is correct, but the explanation is wrong. The error in the second statement occurs because, after the keyword DEFAULT, you must specify an expression, not the name of...

Thanks!

Hallelujah!

What do you mean by "individual join"?

The truly correct answer is "Each full beer name and the first 20 characters of the beer description".

If "beerdescription" is NVARCHAR(MAX), than the "select" returns only 10 characters.

uhm, what about "Temporal tables"?

"Temporal tables" do not need to be backed up and restored, you can see values in the "past" and restore them with a query.

"SQL Server 2016...

• This reply was modified 1 years, 6 months ago by Carlo Romagnano.