SQLServer模拟死锁以及查询死锁进程和表

1、连接SQLServer

3、创建2个表：CREATE TABLE Lock1(C1 int default(0));觊皱筠桡CREATE TABLE Lock2(C1 int default(0));INSERT INTO Lock1 VALUES(1);INSERT INTO Lock2 VALUES(1);

5、再新增一个文件执行：Begin Tran Update Lock1 Set C1=C1+1; WaitFor Delay '00:00:30'; SELECT * FROM Lock2Rollback Tran;

7、然后通过这个SQL查报错的表和进程：SELECT request_session_id spid, OBJECT_NAME( resource_associated_entity_id )tableName FROM sys.dm_tran_locks WHERE resource_type = 'OBJECT'