----
----sql锁表查询和解锁
----
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName ,request_mode
from sys.dm_tran_lockswhere resource_type='OBJECT'
and OBJECT_NAME(resource_associated_entity_id) is not null
order by tableName
declare @spid int
Set @spid = 196 --锁表进程
declare @sql varchar(1000)
set @sql='kill '+cast(@spid as varchar)
exec(@sql)