Sean Lange (3/31/2014)

---

as posted the user absolutely does NOT belong to sysadmin because it was not in the code provided. If it is ok to assume that somebody added this...

Nor is there anything to say that it hasn't,...

James Lean (3/31/2014)

---

The script doesn't mention anything about the creation of king_login, so it is implied that this login already exists. In that case, we cannot assume that it...

No. I almost guessed something different as these questions very rarely have the obvious option as the answer...

Nope, based on the preamble

first confirming the...

That's what...

Interesting question, just a shame that it's let down (as QOTDs so often are) by case inconsistencies.

On a case sensitive database you get several errors and end up with a...

free_mascot (3/11/2014)

---

Yes, initially I have drafted the question straight forward but it looks very simple. Deliberately make it complicated by tricky language to make challenging.

Usually everyone knows correct answer...

Took a lot of thinking to work out all those double negatives!

RLilj33 (2/26/2014)

---

Equivalent to:

SELECT X AS 'Intersecting'

FROM A

JOIN b ON b.y = a.x;

Except the ordering. INTERSECT returns the values in...

Of course the correct answer isn't an option. It fails with an error saying that column X does not exist...

2 points!

Didn't know whether OR or AND had priority, so guessed (correctly 🙂 )

It's not something I've ever really needed to know, doesn't everyone use brackets in cases like this, to...

Interesting question, but the title meant it was easy to get the right answer.

Though it looks like almost half the people who answered didn't read the title 😉

Revenant (12/31/2013)I thought it was understood that QotDs assume default SQL Server installation settings - if we veered off into region-specific settings, QotDs would have to have a dozen lines...