摘要:
查看表是否死锁 select * from master..SysProcesses where db_Name(dbID) = '数据库名' and spId <> @@SpId and dbID <> 0 and blocked >0; 或者 select request_session_id 阅读全文
摘要:
准备基本的数据 create table test_table ( id int identity(0,1), name varchar(20), age int, book_name varchar(50), price float ) insert into test_table values 阅读全文