Second Instance in an example how to test and avoid SQL deadlock

SecondInstance.sql

--2
BEGIN TRAN;
Update TBL_test_temp_two set 
TWOcolumnone =N'AAAAAAAA',
TWOcolumntwo =N'AAAAAAAAAAAAAA'
Where PK =1
And TWOcolumnone =N'AAAAAAAA'
AND TWOcolumntwo = N'AAAAAAAAAAAAAA'
COMMIT;


--4
BEGIN TRAN;
Update TBL_test_temp set 
TESTCOLUMNONE =N'TTTTTTTT',
TESTCOLUMNTWO =N'TTTTTTTTTTTTTT'
Where PK =1
And TESTCOLUMNONE =N'TTTTTTTT'
AND TESTCOLUMNTWO = N'TTTTTTTTTTTTTT'
COMMIT;