09 2017 档案

SQL Server ->> 查询添加XLOCK表提示不阻塞其他线程
摘要：BEGIN TRAN SELECT * FROM [DWQueue].[dbo].[Table_1](XLOCK) WHERE ID = 2 WHILE 1 = 1 BEGIN SELECT GETDATE(),* FROM [DWQueue].[dbo].[Table_1] WHERE ID = 2 END DROP TABLE IF EXISTS... 阅读全文
posted @ 2017-09-07 09:50 Jerry_Chen 阅读(454) 评论(1) 推荐(0)