4.3.7.sql

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

set transaction isolation level repeatable read
BEGIN TRAN
SELECT * FROM TEACHERS WHERE TID='300000000 '
IF @@ROWCOUNT<>0 
    BEGIN
      WAITFOR DELAY '00:00:10'
      SELECT * FROM TEACHERS WHERE TID='300000000'
    END
ROLLBACK TRAN