图形化方法：
命令行方法：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
use master
go
declare
@dbname sysname
set
@dbname =
'BigValuesTest'
--这个是要删除的数据库库名
declare
@s nvarchar(1000)
declare
tb
cursor
local
for
select
s =
'kill '
+
cast
(spid
as
varchar
)
from
master.dbo.sysprocesses
where
dbid = DB_ID(@dbname)
open
tb
fetch
next
from
tb
into
@s
while @@fetch_status = 0
begin
exec
(@s)
fetch
next
from
tb
into
@s
end
close
tb
deallocate
tb
exec
(
'drop database ['
+ @dbname +
']'
)
|
这个原理类似于操作系统里面通过pid干掉程序了
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
