4.3.2.sql

清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
-- 模拟实现脏读
SELECT * FROM TEACHERS WHERE TID='200003125'
IF @@ROWCOUNT<>0 
      BEGIN
        WAITFOR DELAY '00:00:20'
        -- PRINT 模拟实现不可重复读
        SELECT * FROM TEACHERS WHERE TID='200003125'
END