Shulou(Shulou.com)06/01 Report--

View locked table statement

-- View locked table: SELECTrequest_session_id spid,OBJECT_NAME (resource_associated_entity_id) tableNameFROMsys.dm_tran_locksWHEREresource_type = 'OBJECT' ORDER BY request_session_id ASC--spid locked table process-- tableName locked table name-- query the SQL statement DBCC INPUTBUFFER of the corresponding process interlock according to the locked table process

Unlock statement

-- unlock: DECLARE@spid INTSET @ spid = 52murl-Lock table process DECLARE@SQL VARCHAR (1000) SET @ SQL = 'kill' + CAST (@ spid AS VARCHAR) EXEC (@ SQL)

Generate an unlocked SQL statement

-- generate unlocked SQLSELECTDISTINCT 'DECLARE @ spid INT SET @ spid =', request_session_id,' DECLARE @ SQL VARCHAR (1000) SET @ SQL =''kill''+ CAST (@ spid AS VARCHAR) EXEC (@ SQL);'as sFROMsys.dm_tran_locksWHEREresource_type = 'OBJECT'-- spid locking table process-- tableName locked table name

Summary

This is the whole content of this article about sqlserver: query locking sql and unlocking method. I hope it will be helpful to you. Interested friends can continue to refer to: MYSQL subquery and nested query optimization instance parsing, several more important MySQL variables, ORACLE SQL statement optimization technical points analysis, etc. If there is any problem, you can leave a message, editor will reply you in time, and strive to provide the majority of programming hobbies and workers with better quality articles and better reading experience. Thank you for your support to this site!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.