Nice clear and unambiguous question. Back to basics, really. Possibly difficult for people who are used to working with ANSI WARNINGS ON, but pretty basic for the rest...

Miles Neale (3/1/2013)

---

Hugo - The text on the email reads as follows:

Think you know the answer? Click here, and find out if you are right.

This question is worth 1 point...

PAPER

FLOP

Another of those awful questions where one has to guess at the intention of the author, because it isn't made at all clear, and in fact what looks like the...

Hugo Kornelis (2/28/2013)

---

I guess I should have put it more clearly. "If you want to exclude rows from the source from the MERGE action, I recommend using a derived table...

Hugo Kornelis (2/28/2013)

---

My guess is that ALTER USER WITHOUT LOGIN was explicitly added to the product to introduce a way to create a principal and then give authorizations to that...

Hugo Kornelis (2/28/2013)

---

Coming into this a bit late....

Another (better, I think) way to explain this, is to think of the USING ... ON as a FULL OUTER JOIN. After performing...

It's a nice simple question. And a good explanation.

However, the reference in the explanation to Rob Conery's adaption of Itzak's description is a bit unfortunate, because he recommends "a...

I've been in Lanzarote for the last 5 months, apart from a few days in England in September...

batgirl (2/27/2013)

---

Many years ago I was working to support a SQL Server based accounting system and had a very troubling issue that was ultimately found to have been caused by...

Raghavendra Mudugal (2/27/2013)

---

actually... mine does. I am using the below version

Microsoft SQL Server 2012 - 11.0.2218.0 (X64)

Jun 12 2012 13:05:25

Copyright (c) Microsoft Corporation

Express Edition (64-bit) on Windows NT...

Nice question, but two (very minor) niggles: (i) what was the last statement for? and (ii) why refer in the explanation to the output clause returning rows to the client...

Raghavendra Mudugal (2/27/2013)

---

(note : I know (and most of all know) collation is very important and each server/database/table or any object which is qualified for using collation has one by...

mike brockington (2/26/2013)

---

I think you are both missing the point, which is that the original question was seriously lacking in detail, and fell way below the level of professionalism that...