34 - nestedtranstrancount.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 14 行

BEGIN TRAN ShareUpd
   SELECT '1st TranCount',@@TRANCOUNT
   BEGIN TRAN ShareUpd2
      SELECT '2nd TranCount',@@TRANCOUNT
      COMMIT TRAN ShareUpd2
      SELECT '3rd TranCount',@@TRANCOUNT
COMMIT TRAN -- It is at this point that data modifications will be committed
SELECT 'Last TranCount',@@TRANCOUNT