Steph Locke (10/28/2013)

---

I have a three syllable forename and used to have a three syllable surname. There's not enough time in my life to warrant wasting it by speaking or...

As far as I know, my name is unique. Doing an online search for my name finds only me and people called Marlon but with a different surname at...

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 a...

When I was younger, people would, when told my first name, often respond with 'As in Brando?'. This is much less common now and if I make the statement...

ditto

Muchas gracias.

Bhuvnesh (10/16/2013)

---

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

---

ROLLBACK always (unless you specify an invalid transaction name) sets @@trancount to 0 and rolls back the transaction (unless @@trancount is already 0, in which...

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

---

Bhuvnesh (10/16/2013)

---

But I made the wrong selection . beacuse i was thinking (and this was my understanding ..earlier) that once the commit has been fired, the following...

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

---

David Burrows (10/14/2013)

---

Nice question.

Due to the amount of criticism of previous QOD of the phrasing of the Q'a and A's I am surprised that no one posted...

Charles Kincaid (10/15/2013)

---

Almost to the same level of performance boost that can be obtained by moving some predicated to the JOIN instead of leaving them in the WHERE (but that...

Hugo Kornelis (10/15/2013)

---

2. Please don't hesitate to disagree with me more often. I'm wrong quite often, as my children will be happy to tell you. If you have a different...

David Burrows (10/15/2013)

---

The...

I got this right because we'd been bitten on the ar*e by this when first amending our system to work with SQLServer as well as Oracle.

Ditto.

Ditto. I wonder what happens if the CTE is built from more than one table?