SQL Server 锁的概念
锁状态查看
select request_session_id,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks
此表的字段含义参考 https://msdn.microsoft.com/zh-cn/library/ms190345.aspx 链接。
select request_session_id,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks
此表的字段含义参考 https://msdn.microsoft.com/zh-cn/library/ms190345.aspx 链接。