GF (10/14/2008)

---

Jeff, this is a great article.

I do have a question as I am trying to apply your solution to my needs.

I have hundreds of addresses in a single address...

arup_kc (10/14/2008)

---

Hi Carlo,

I have tested it several times in SQL Server 2000 and 2005. Every time, it gives NULL first. I guess that it shows the NULL first because NULL...

It's still supported by SQL Server 2008, even though it's on the list...

JohnG (9/5/2008)

---

Only if you have one and only one trigger in the entire database!

The trigger that was fired and thus sets @@ROWCOUNT to zero could be some DML operation in...

JohnG (9/5/2008)

---

Hugo Kornelis (9/5/2008)

---

That's why many developers make it a habit to start each trigger with this line:

IF @@ROWCOUNT = 0 RETURN;

Do make sure that it's the very first line...

Lynn Pettis (9/5/2008)

---

I must not fully understand INSERT triggers, but I was always under the impression that if nothing was inserted, an insert trigger WON'T fire. I have never...

Lynn Pettis (9/4/2008)

---

Not sure if MERGE is needed here. The question only indicted that a record needed to be inserted if it did not already exist in the database....

.... that I seem to have overlooked thus far. And now I find myself wondering what it is...

davidr (9/4/2008)

---

side note: we shouldn't really be doing "select *" to check for existence. If that's a LOONNNNGGGGG row there could be a lot of overhead to...

Hi Joe,

I assume you meant me, not Chris. 🙂

The second solution has to do...

Christian Buettner (9/4/2008)

---

Nice question, but not "totally" deterministic in my opinion.

What If I ensure consistency through the transaction isolation level already?

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

BEGIN TRANSACTION

IF NOT EXISTS......

EdVassie (9/1/2008)

---

I don't think that the question gives enough detail to say that limiting SQL Server memory to 512 MB is the right answer.

(snip)

So, if you simply dive...

Christian Buettner (9/1/2008)

---

Hm, I am not sure whether I am correct, but from the QOTD, it is not clear whether the several steps involve the same tables or different tables....

Atif Sheikh (9/1/2008)

---

Nicely Explained... the question needed such an explanation as all the options would have worked for the scenario but with some limitations and issues.

But I am still confused...

Hi Jeff,

Well, I *did* write "usually"! 😀

Of drat, I now see I didn't...