摘要: 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 阅读全文
posted @ 2011-11-10 22:28 第7笔画 阅读(256) 评论(0) 推荐(0) 编辑