use tempdb drop table DeadLock_A create table DeadLock_A ( id int identity(1,1) primary key, name varchar(10), gender char(1) ) insert into DeadLock_A(name, gender) values('Tom', 'M') insert into DeadLock_A(name, gender) values('John', 'M') insert into DeadLock_A(name, gender) values('Jane', 'F') insert into DeadLock_A(name, gender) values('Shon', 'M') insert into DeadLock_A(name, gender) value..