SQL Server ->> 查询添加XLOCK表提示不阻塞其他线程

最新推荐文章于 2021-07-01 22:42:08 发布

weixin_30399155

最新推荐文章于 2021-07-01 22:42:08 发布

阅读量301

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/jenrrychen/p/7488193.html

版权

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 tempdb..#t

CREATE TABLE #t
(
    spid int,
    dbid int,
    ObjId int,
    IndId int,
    Type nvarchar(50),
    Resource nvarchar(200),
    Mode nvarchar(200),
    Status nvarchar(50),
    CREATEDT DATETIME DEFAULT(GETDATE())
) 

WHILE 1 = 1
BEGIN
    INSERT INTO #t
    (
    spid,dbid,ObjId,IndId,Type,Resource,Mode,Status
    )
    EXEC sp_lock
END


--SELECT * FROM #T WHERE spid = 58  ORDER BY CREATEDT