解锁

最新推荐文章于 2025-02-02 16:55:44 发布

feegle_develop

最新推荐文章于 2025-02-02 16:55:44 发布

阅读量1.7k

点赞数 1

分类专栏： MSSQL 文章标签： object kill table insert null

本文链接：https://blog.csdn.net/feegle_develop/article/details/6450505

版权

MSSQL 专栏收录该内容

29 篇文章

订阅专栏

create procedure sp_kill(@tbname varchar(100),@dbname varchar(100))
as
begin
 declare @spid int

 if OBJECT_ID('tempdb.dbo.#Kill') is not null
 drop table #Kill

 create table #Kill
 (
 [spid] int,
 [dbid] int,
 [ObjId] int,
 [IndId] int,
 [Type] varchar(50),
 [Resource] varchar(50),
 [Mode] varchar(20),
 [Status] varchar(100)
 )

 INSERT INTO #Kill([spid],[dbid],[ObjId],[IndId],[Type],[Resource],[Mode],[Status])
 exec sp_lock

 while (select COUNT(*) from #Kill where ObjId=OBJECT_ID(@tbname) and dbid=DB_ID(@dbname))<>0
 begin
 set @spid=(
 select top 1 spid
 from #Kill
 where ObjId=OBJECT_ID(@tbname) and dbid=DB_ID(@dbname)
 )
 exec('kill '+@spid)
 end

end
go