随笔分类 -  Sql Server

SQL Server 中锁表查询操作
摘要：1 --查询是否存在阻塞信息 2 select bl.spid blocking_session,bl.blocked blocked_session,st.text blockedtext from (SELECT spid ,blocked 3 FROM (SELECT * FROM sys.sysprocesses WHERE blocked>0 ) a 4 ... 阅读全文
posted @ 2018-08-11 00:53 Jarman 阅读(2151) 评论(0) 推荐(0)