摘要:
use masterdeclare @dbname sysname set @dbname='AAA' --这个是要删除的数据库库名 IF EXISTS (SELECT * FROM SYSDATABASES WHERE name=@dbname) BEGIN declare @s nvarchar(1000) declare tb cursor local for select s='kill '+cast(spid as varchar) from master..sysprocesses where dbid=db_id(@dbname) open tb 阅读全文