將某表設置X鎖1分鐘：

begin tran
select top 1 * from tableName?with (tablockx)
waitfor delay '00:01:00'
commit tran

查詢當前被鎖的表：

--查詢鎖表的事務ID，被鎖表名，鎖模式，客戶端主機名，客戶端程序名，客戶端IP地址
select tl.request_session_id as [事務ID],
? ? ? ?object_name(tl.resource_associated_entity_id) as [被鎖表名],
? ? ? ?tl.request_mode as [鎖模式],
? ? ? ?es.host_name as [客戶端主機名],
? ? ? ?es.program_name as [客戶端程序名],
? ? ? ?ec.client_net_address as [客戶端IP地址]
from sys.dm_tran_locks as tl
join sys.dm_exec_sessions as es
on tl.request_session_id = es.session_id
join sys.dm_exec_connections as ec
on es.session_id = ec.session_id --或者 on tl.request_owner_id = ec.connection_id
where tl.resource_type = 'OBJECT' --只查表級別的鎖
and tl.request_mode in ('X','IX') --只查排他鎖和意向排他鎖

解鎖：

declare @spid??int?
Set @spid??= 57 --鎖表進程
declare @sql varchar(1000)
set @sql='kill '+cast(@spid??as varchar)
exec(@sql)