34,590
社区成员
发帖
与我相关
我的任务
分享
--加上[]
--應該有數據開頭的數據庫名
use master
go
declare @str varchar(50)
declare @strExec varchar(150)
DECLARE contact_cursor CURSOR FOR
SELECT name FROM sysdatabases where dbid>4
OPEN contact_cursor
FETCH NEXT FROM contact_cursor INTO @str
WHILE @@FETCH_STATUS = 0
BEGIN
set @strExec='drop database [' + @str+']'--加上[]
print @strExec
exec(@strExec)
FETCH NEXT FROM contact_cursor INTO @str
END
CLOSE contact_cursor;
DEALLOCATE contact_cursor;
set @strExec='drop database ' + QUOTENAME(@str)