为学日损

摘要： 一、查看锁select * from sysprocesses where blocked<>0二、SqlServer经常因为某些语句或事物的误操作造成死锁。查询导致死锁的表和进程ID：select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName fromsys.dm_tran_locks whereresource_type='OBJECT 杀掉死锁：kill spid 阅读全文