Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 快速断开当前数据库的所有连接的方法

快速断开当前数据库的所有连接的方法

WBOY
Release： 2016-06-07 17:45:09
Original
1749 people have browsed it

快速断开当前数据库的所有连接的方法 以前我喜欢执行这个脚本，然后当要断开所有连接的时候就执行一下这个脚本，但是当我重装SQLSERVER的时候，又要在代码库里 找到这个脚本执行觉得很不方便，实际上分离数据库也能够断开所有连接 1 USE master ANSI_NULLS Q

快速断开当前数据库的所有连接的方法

以前我喜欢执行这个脚本，然后当要断开所有连接的时候就执行一下这个脚本，但是当我重装SQLSERVER的时候，又要在代码库里

找到这个脚本执行觉得很不方便，香港空间，香港虚拟主机，实际上分离数据库也能够断开所有连接

1 USE master ANSI_NULLS QUOTED_IDENTIFIER .(100) ((30) (VARCHAR, spid) AS spId 19 FROM master..SysProcesses (dbid) spid dbid TmpCursor TmpCursor (@killspId) TmpCursor TmpCursor 36 DEALLOCATE TmpCursor ，虚拟主机

Related labels：
fast database disconnect method connect
source：php.cn
Previous article： 存储过程分页 Next article： 利用自定义分页技术提高数据库性能
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Trouble getting specific statistics (Stats) from PokeAPI using Axios and Node.js I have a problem, I'm trying to use the PokemonAPI, but when I try to access the attack, H...
From 2024-04-06 18:46:35
0
1
464
Releasing the X-axis after calling Chart.zoom(): a step-by-step guide I set the scroll strategy to setScrollStrategy(AxisScrollStrategies.progressive) and on th...
From 2024-04-04 23:40:56
0
1
1339
How to customize HTML code to quickly modify content I have created a website where I want to constantly modify data. This means adding more te...
From 2024-04-04 21:08:14
0
1
3462
My multiply (*) command doesn't calculate My asterisk is not working, when I do the calc() function and do the multiplication notati...
From 2024-04-04 21:18:17
0
1
315
return(); doesn't work for 1 route but works for almost the same route I have 2 routes, one for unsubscribing and one for restoring, both routes are the same exc...
From 2024-04-04 17:34:09
0
1
311
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template