4.1.4.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 11 行

SELECT 'BEFORE TRANSACTION:         ' AS HINT,@@TRANCOUNT AS TRANACTIONCOUNT
BEGIN TRAN
SELECT 'THE FIRST TRANSACTION STARTS:           ' AS HINT,@@TRANCOUNT  AS TRANACTIONCOUNT
    SELECT TOP 3 * FROM CHOICES
    BEGIN TRAN
       SELECT 'THE SECOND TRANSACTION STARTS:       ' AS HINT,@@TRANCOUNT  AS TRANACTIONCOUNT
    COMMIT TRAN
    SELECT 'THE SECOND TRANSACTION COMMITS' AS HINT,@@TRANCOUNT AS TRANACTIONCOUNT
ROLLBACK TRAN
    SELECT 'THE FIRST TRANSACTION ROLL BACK' AS HINT,@@TRANCOUNT AS TRANACTIONCOUNT