SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
-- 初始狀態
BEGIN TRAN
SELECT * FROM TEACHERS WHERE TID='200003125'
IF @@ROWCOUNT<>0 
    BEGIN
      WAITFOR DELAY '00:00:20'
     -- PRINT 模擬實現不可重復讀
      SELECT * FROM TEACHERS WHERE TID='200003125'
    END
ROLLBACK TRAN