Hugo Kornelis (1/22/2015)

---

DTML (1/22/2015)

---

The only problem I have with this QoD, is that the INSERT statement fails as the column 'myid' does not allow nulls, as it is treated as...

Steve Jones - SSC Editor (1/21/2015)

---

They return the same value. Althought COUNT does consider NULL rows, it does so only when the * is used. If an expression is used,...

marlon.seton (10/28/2013)

---

L' Eomot Inversé (10/28/2013)

---

Nice question.

Has one small problem though: the code leaves a transaction open - nothing is actually committed.

It's clearly stated in BOL:-

Although each COMMIT TRANSACTION statement has...