I didn't really care so just guessed and got it right.

Most developers will only ever use one method. That may depend on in-house standards but I'd recommend that used...

Nice to see a "real world" question on here. At the moment roughly 25% of respondents have gone for the answer which would make any US record with a missing...

edwardwill (8/3/2015)

---

Toreador (8/3/2015)

---

Hardly an abject failure, he just got one word wrong.

Though I was looking for a "none of the above" answer to "which of these queries will do this",...

Nice question - I did not see that coming!

Also a good illustration of why NOT IN can be very risky. Using NOT EXISTS instead gives the result that would probably be intended in this scenario:

SELECT Value

FROM #tmpNewValue new

WHERE...

This was the question titled "Max DB Size...

That would certainly achieve the stated goal.

Plus some other ones.......

Well, the query returned the two table names and the name of the foreign key.

What it didn;t do was show the relationship (i.e. columns) between the two.

To me,...

Unusually I thought it was quite an easy question and that two points was a bit generous. But then I saw that more people were getting it wrong than right...

Only an easy question if you know all of the SQL Server error codes. Otherwise the only way to get it right is to cheat and run the code.

Just out of interest is there a rule or convention on what these symbols are called? Strictly speaking,

' is an apostrophe, and

" is a quote.

Confusion sets in when terms...

The question featured checkboxes rather than radio buttons and...

We've just elected the Ragged Right to run our country for another five years.

There's a good article at Simple Talk[/url] which mentions the limit and the reason.

Where it says "116 characters or less" it means "116 characters or fewer" 😉

It should have been possible to attempt an answer without just running the code. And, given the title of the question, it should have been clear that the "tmp" error...