Thomas Abraham (5/16/2012)

---

Thanks for the question.

Got it wrong, and I even ran a test. Code below:

CREATE TABLE #Temp(Col1 INT NOT NULL

CONSTRAINT PK_QOTD_1 PRIMARY KEY (Col1))

...

Christian Buettner-167247 (5/16/2012)

---

Hm, I am a little confused because of the missing comma before the CONSTRAINT declaration. That does not seem to be required based on a first test. But...

Nice question. I knew about implicit transaction, but I had to do some digging because I couldn't remember if primary key violation errors are batch-aborting or not.

(One possible -slight!- improvement...

L' Eomot Inversé (5/14/2012)

---

It seems unlikely that 40% of people are unaware that this has changed since SQL Server 2000, and there's no other sensible reason for anyone to get...

So I guess you are running SQL Server 2005 or older?

The ability...

Good question, but a BIG mistake in the explanation!!

"COALESCE returns a datatype from the first non-null value in the statement depending on data type precedence"

The datatype of the first non-null...

WayneS (5/10/2012)

---

Hugo:

I tried (and sent this QotD to several folks to get their opinions) to make this a good QotD without this controversy. How would you have worded this to...

L' Eomot Inversé (5/10/2012)

---

Good question, but wrong answer given as right.

The wrong answer made no points difference to me, because I managed to get it utterly wrong even...

jalvarocrespo (5/10/2012)

---

Tricky question indeed.

Well, but I can't find any difference between the result obtained and my response: When the table contains sparse columns and a sparse column set, then any...

Good question, Wayne. And thanks Koen for the additional reference.

Also, the result set in the explanation is not really correct. The ColumnSet row will display XML data. I assume that...

L' Eomot Inversé (5/9/2012)

---

Hugo Kornelis (5/9/2012)

---

Nice question!

However, the explanation and reference are slightly incomplete, as they don't explain the behaviour of @A LIKE @b-2 versus @ LIKE @A.

The explanation for...

jalvarocrespo (5/9/2012)

---

From BOL,

UNIQUE

Creates a unique index on a table or view. A unique index is one in which no two rows are permitted to have the same index key...

Nope. You can create an index on...

Nice question!

However, the explanation and reference are slightly incomplete, as they don't explain the behaviour of @A LIKE @b-2 versus @ LIKE @A.

The explanation for that can simply be found...

You would have found...