4.4.3.sql

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

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN TRAN
    SELECT * FROM TEACHERS WHERE TID='200003125'
    WAITFOR DELAY '00:00:05'
    UPDATE TEACHERS SET SALARY=4000 WHERE TID='200003125'
COMMIT TRAN
    SELECT * FROM TEACHERS WHERE TID='200003125'