12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-11-29 09:50:59
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
--查看被锁表：SELECTrequest_session_idspid,OBJECT_NAME(resource_associated_entity_id)tableNameFROMsys.dm_tran_locksWHEREresource_type='OBJECT'ORDERBYreque
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
--查看被锁表：
SELECTrequest_session_idspid,OBJECT_NAME(resource_associated_entity_id)tableNameFROMsys.dm_tran_locksWHEREresource_type='OBJECT'ORDERBYrequest_session_idASC--spid锁表进程--tableName被锁表名
--根据锁表进程查询相应进程互锁的SQL语句
DBCC INPUTBUFFER (249)
-- 解锁：
DECLARE@spidINTSET@spid=52--锁表进程DECLARE@SQLVARCHAR(1000)SET@SQL='kill'+CAST(@spidASVARCHAR)EXEC(@SQL)
--生成解锁SQL
SELECTDISTINCT'DECLARE@spidINTSET@spid=',request_session_id,'DECLARE@SQLVARCHAR(1000)SET@SQL=''kill''+CAST(@spidASVARCHAR)EXEC(@SQL);'assFROMsys.dm_tran_locksWHEREresource_type='OBJECT'--spid锁表进程--tableName被锁表名
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19