Workaround for SQL Server table deadlock

1 first create a test table:

Copy the code code as follows:

CREATE TABLE Test (TID INT IDENTITY)

2 Execute the following SQL statement to lock the table:

Copy the code code as follows:

SELECT * from Test with (Tablockx)

3 You can see which tables in the current library are deadlocked by using the following statement:

Copy the code code as follows:

SELECT request_session_id spid,object_name (resource_associated_entity_id) tableName from Sys.dm_tran_locks WHERE Resource_type= ' OBJECT '

4 The result of the above statement execution is as follows:

　　

SPID: The process ID being locked. TableName: The name of the table where the deadlock occurred.
5 only use the KILL keyword to kill the locked process ID to unlock the table:
KILL 52