[代码实例][SQLServer]关闭连接

最新推荐文章于 2020-03-20 08:51:30 发布

cloudblaze

最新推荐文章于 2020-03-20 08:51:30 发布

阅读量906

点赞数

分类专栏：代码实例

本文链接：https://blog.csdn.net/cloudblaze/article/details/54590296

版权

代码实例专栏收录该内容

33 篇文章 0 订阅

订阅专栏

IF EXISTS
(
    SELECT * 
        FROM master.sys.databases
        WHERE name='EducationDB'
)
BEGIN
    DECLARE @spid VARCHAR(20)
    DECLARE curDBLogin CURSOR FOR
        SELECT CAST(spid AS VARCHAR(20)) AS spid
            FROM master.sys.sysprocesses
            WHERE dbid=DB_ID('EducationDB');
    OPEN curDBLogin;
    FETCH NEXT FROM curDBLogin INTO @spid;
    WHILE @@FETCH_STATUS=0
    BEGIN
        IF @spid!=@@SPID
            EXEC('KILL ' + @spid)
        FETCH NEXT FROM curDBLogin INTO @spid
    END
    CLOSE curDBLogin;
    DEALLOCATE curDBLogin;

    DROP DATABASE EducationDB;
END
GO