摘要: --创建测试表CREATE TABLE test1(id int)delete会话一BEGIN TRANdelete test1INSERT test1SELECT 1会话二INSERT test1SELECT 1一先,二后,二瞬间完成,没有发生阻塞---------------------------------------------------------------------sp_lock------------------------------------------------------------------------------------------------tru 阅读全文
posted @ 2012-06-09 10:21 qanholas 阅读(626) 评论(0) 推荐(1) 编辑
点击右上角即可分享
微信分享提示