sql 表插锁 解锁

  --查锁
  select   request_session_id   spid,OBJECT_NAME(resource_associated_entity_id) tableName   
from   sys.dm_tran_locks where resource_type='OBJECT'


--解锁
KILL 61

  

原文地址:https://www.cnblogs.com/yyzyou/p/4725427.html