vk-kirov (10/19/2010)

---

Hugo Kornelis (10/19/2010)

---

With this additional information, I'd argue that options 2 and 4 are both correct.

And what do you think about counting uncommitted records, is it such a reliable thing?

CREATE TABLE dbo.QOTD_TEST (ID INT PRIMARY KEY);

INSERT dbo.QOTD_TEST VALUES(1);
INSERT dbo.QOTD_TEST VALUES(2);
INSERT dbo.QOTD_TEST VALUES(3);

BEGIN TRAN;
INSERT dbo.QOTD_TEST VALUES(4);
INSERT dbo.QOTD_TEST VALUES(5);

SELECT COUNT(*) FROM dbo.QOTD_TEST;

DELETE dbo.QOTD_TEST WHERE ID IN (2, 3, 4);
COMMIT TRAN;