• That wont cause a deadlock, that will cause blocking.

    You need to do things in a different order, eg 1 query update t1 then t2, other query update t2 then t1

    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