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

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;ENDGO