Good question, thanks for submitting, Honza! I agree that it was clear enough that the code was supposed to be run as a single batch.

To the person posting that "select...

Rune Bivrin (5/2/2013)

---

Hugo Kornelis (5/2/2013)

---

However, to do some nitpicking:

1. If I were to try this code on my system, I would get five errors. All system table (*) names are...

EDIT: Double post removed.

(I got an error message when posting, so I assumed the post didn't go through. Should have checked before reposting)

Good question, though I'm surprised that, apparently, people are doing this wrong. Since you'll be rewarded by an error message when you try, I don't understand how people could not...

flangoo (5/1/2013)

---

Yes to me too it is returning only 1 count.

When ist row is being inserted and the trigger fires and there is sucessful insertion and in second insert when...

Raghavendra Mudugal (5/1/2013)

---

sorry; I have hard time in understanding/realizing the missing piece here.

- Replicate is replicating as needed (the expression is 5 chars and and @s-2 is also 5...

This will cost you more time than it'll cost me! 😛

Short answer: no.

Long answer:

1. NULL...

<nitpicking>

Not NULL - Unknown. Quite different concepts!...

Sean Lange (4/30/2013)

---

I don't think I follow you here Tom. The condition checks is @ToCreate = 1. It does not equal 1 because it is NULL. Therefore the boolean check...

Don't feel too bad about it, Steven. It happens to all of us.

It was a great effort, and I hope you'll submit more questions in the future.

call.copse (4/29/2013)

---

I got it right by reading the documentation and assuming the question had been inverted by ascertaining that there were 3 official hints that did not require WITH, so...

Too bad the question author somewhere switched the two options in his head and marked the wrong answers as right and the right answers as wrong. Fortunately, I did the...

I first focused on the reference to a unique constraint rather than the primary key, thinking that was the issue of the question. I almost got it wrong because of...

L' Eomot Inversé (4/25/2013)

---

But I have a minor quibble: if this is a business rule, it should be enforced by the schema if possible, not by code; and this is...

Very good, and very clever question. Well done! 😉