有关事务的问题

CREATE TABLE Texttran (cola INT PRIMARY KEY,colb CHAR(3))
GO
BEGIN TRANSACTION outertran--@@TRANCOUNT set to 1.
GO
INSERT INTO testtran VALUES(1,'aaa')
GO
BEGIN TRANSACTION inner1--@@TRANCOUNT set to 2.
GO
INSERT INTO texttran VALUES(2,'bbb')
GO
BEGIN TRANSACTION inner2--@@TRANCOUNT set to 3.
GO
INSERT INTO testtran VALUES(3.'CCC')
GO
COMMIT TRANSACTION inner2--decrements @@TRANCOUNT to 2.
GO
COMMIT TRANSACTION inner1--decrements @@TRANCOUNT to 1.
GO
COMMIT TRANSACTION outertran--decrements @@TRANCOUNT to 0.
是什么意思?能说的详细些吗?
[678 byte] By [changyuming-常] at [2008-2-13]
# 1
事务嵌套;
由外到内,依次为第1层,第2层,第3层(,...第n层);
@@TRANCOUNT 是事务自动管理变量,反应了事务的嵌套级别;
supsuccess-火气不小 at 2007-10-20 > top of Msdn China Tech,MS-SQL Server,基础类...