CREATE TABLE TEST(

id INT NOT NULL,

name VARCHAR(50)

)

--This would still insert because two inserts are considered different transactions because you

--explicitly didn't committed it yet!

BEGIN TRAN

INSERT INTO TEST(id, name) VALUES(1,'a')

INSERT INTO...