摘要:
--创建测试表CREATE TABLE test1(id int)delete会话一BEGIN TRANdelete test1INSERT test1SELECT 1会话二INSERT test1SELECT 1一先,二后,二瞬间完成,没有发生阻塞---------------------------------------------------------------------sp_lock------------------------------------------------------------------------------------------------tru 阅读全文