blocks|key|773216|text|为什么不这样做呢？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|773217|USE+master;
Go
SELECT+'DROP+DATABASE+['%2B+name+%2B+']'+
FROM+sys.databases+WHERE+name+like+'_database_name_%25';
GO|code-block|syntax|javascript|773218|捕获该结果集的输出，然后将其粘贴到另一个查询窗口中。然后运行它。为什么要写这么多TSQL游标代码呢？|773219|“当你有锤子的时候，所有的东西看起来都像钉子！”|773220|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Why not just do this instead? 

<pre><code>USE master;
Go
SELECT 'DROP DATABASE ['+ name + ']' 
FROM sys.databases WHERE name like '_database_name_%';
GO
</code></pre>

Capture the output of that resultset and then paste it into another query window. Then run that. Why write all this TSQL cursor code? 

"When you have a hammer, everything looks like a nail!"..

blocks|key|773228|text|这很简单。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|773229|use+master
go
declare+@dbnames+nvarchar(max)
declare+@statement+nvarchar(max)
set+@dbnames+=+''
set+@statement+=+''
select+@dbnames+=+@dbnames+%2B+',['+%2B+name+%2B+']'+from+sys.databases+where+name+like+'name.of.db%25'
if+len(@dbnames)+=+0
++++begin
++++print+'no+databases+to+drop'
++++end
else
++++begin
++++set+@statement+=+'drop+database+'+%2B+substring(@dbnames,+2,+len(@dbnames))
++++print+@statement
++++exec+sp_executesql+@statement
++++end|code-block|syntax|javascript|773230|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

this is easy...

<pre><code>use master
go
declare @dbnames nvarchar(max)
declare @statement nvarchar(max)
set @dbnames = ''
set @statement = ''
select @dbnames = @dbnames + ',[' + name + ']' from sys.databases where name like 'name.of.db%'
if len(@dbnames) = 0
 begin
 print 'no databases to drop'
 end
else
 begin
 set @statement = 'drop database ' + substring(@dbnames, 2, len(@dbnames))
 print @statement
 exec sp_executesql @statement
 end
</code></pre>

blocks|key|988614|text|不需要使用游标，也不需要复制和粘贴SQL语句。只需运行以下两行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|988615|声明@Sql+as+NVARCHAR(MAX)+=+(SELECT+'DROP+DATABASE+'%2B+name+%2B+'；‘FROM+sys.databases+WHERE+name+LIKE+'DBName%25’作为XML路径(‘’))|988616|EXEC+sys.sp_executesql+@Sql|988617|当然，任何符合条件的数据库都将被立即删除，因此请确保您知道自己在做什么。|988618|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

There is no need to use a cursor, and no need to copy and paste SQL statements. Just run these two lines:

DECLARE @Sql as NVARCHAR(MAX) = (SELECT 'DROP DATABASE ['+ name + ']; ' FROM sys.databases WHERE name LIKE 'DBName%' FOR XML PATH(''))

EXEC sys.sp_executesql @Sql

Of course, any DB matching the criteria will be dropped immediately, so be sure that you know what you are doing.

Just to clarify, ths isn't really a question, more some help for people like me who were looking for an answer. 
A lot of applications create temp tables and the like, but I was surprised when Team Foundation Server created 80+ databases on my test SQL Server. TFS didn't install correctly, and kindly left me to clear up after it. Since each database had a naming convention, rather than delete each database by hand, I remembered how to use cursors and have written what I view to be the most unwise piece of T-SQL ever:

<pre><code> CREATE TABLE #databaseNames (name varchar(100) NOT NULL, db_size varchar(50), owner varchar(50), dbid int, created date, status text, compatibility_level int);
INSERT #databaseNames
 exec sp_helpdb;

DECLARE dropCur CURSOR FOR
 SELECT name FROM #databaseNames WHERE name like '_database_name_%';
OPEN dropCur;
DECLARE @dbName nvarchar(100);
FETCH NEXT FROM dropCur INTO @dbName;
DECLARE @statement nvarchar(200);
WHILE @@FETCH_STATUS = 0
BEGIN
 SET @statement = 'DROP DATABASE ' + @dbName;
 EXEC sp_executesql @statement;
 FETCH NEXT FROM dropCur INTO @dbName;
END
CLOSE dropCur;
DEALLOCATE dropCur;
DROP TABLE #databaseNames;
</code></pre>

It goes without saying that using cursors like this is probably really dangerous, and should be used with extreme caution. This worked for me, and I haven't seen any further damage to my database yet, but I disclaim: use this code at your own risk, and back up your vital data first! 
Also, if this should be deleted because it's not a question, I understand. Just wanted to post this somewhere people would look.

How to drop multiple databases in SQL Server

5位重磅专家聚焦 AI 时代开发者核心成长需求，带你深入解锁全栈进化、人机协作关键路径！点击报名到场：<a href="https://cloud.tencent.com/developer/salon/salon-2403/signup" target="_blank">https://cloud.tencent.com/developer/salon/salon-2403/signup</a> 
 <img src="https://qcloudimg.tencent-cloud.cn/raw/487c82639d2338df3ef66dfb1450601a.png"/>

腾讯技术创作特训营「年度论坛」正在报名中！

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

只是澄清一下，这不是一个真正的问题，更多的是对像我这样正在寻找答案的人的一些帮助。很多应用程序都会创建临时表之类的东西，但当Team Foundation Server在我的测试SQL Server上创建80+数据库时，我感到很惊讶。TFS没有正确安装，请让我在安装后进行清理。因为每个数据库都有一个命名约定，而不是手动...

问如何在SQL Server中删除多个数据库
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server中删除多个数据库EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server中删除多个数据库
EN