CREATE TABLE t1 (i int);
 CREATE TABLE t2 (i int);
 
 INSERT t1 SELECT 1;
 INSERT t2 SELECT 9;
 
 
 /* in one window enter: */
 BEGIN TRAN
 UPDATE t1 SET i = 11 WHERE i = 1
 WAITFOR DELAY '00:00:20'
 UPDATE t2 SET i = 99 WHERE i = 9
 COMMIT
 
 /* in a second window (another transaction) enter: */
 BEGIN TRAN
 UPDATE t2 SET i = 99 WHERE i = 9
 WAITFOR DELAY '00:00:20'
 UPDATE t1 SET i = 11 WHERE i = 1
 COMMIT