Create SQL server deadlock simulation

createtable.sql

Create table vin_deadlock (id int, Name Varchar(30))

GO

Insert into vin_deadlock values (1, 'Vinod')

Insert into vin_deadlock values (2, 'Kumar')

Insert into vin_deadlock values (3, 'Saravana')

Insert into vin_deadlock values (4, 'Srinivas')

Insert into vin_deadlock values (5, 'Sampath')

Insert into vin_deadlock values (6, 'Manoj')

GO

transaction1.sql

Begin Tran
Update vin_deadlock
SET Name = 'Manoj'
Where id = 6
WAITFOR DELAY '00:00:10'
Update vin_deadlock
SET Name = 'Vinod'
Where id = 1

transaction2.sql

Begin Tran
Update vin_deadlock
SET Name = 'Vinod'
Where id = 1
WAITFOR DELAY '00:00:10'
Update vin_deadlock
SET Name = 'Manoj'
Where id = 6