Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about the sqlserver query locking sql and what is the unlocking method. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

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 above is the lock sql and unlocking method of the sqlserver query shared by Xiaobian. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.