收缩当前SQLServer实例中所有的数据库 无 DECLARE @sql nvarchar(300)?DECLARE ShrinkAllDBs CURSORREAD_ONLYFOR select name from sysdatabases?DECLARE @name nvarchar(255)OPEN ShrinkAllDBs?FETCH NEXT FROM ShrinkAllDBs INTO @nameWHILE (@@fetch_statu
收缩当前SQL Server实例中所有的数据库DECLARE @sql nvarchar(300) ? DECLARE ShrinkAllDBs CURSOR READ_ONLY FOR select name from sysdatabases ? DECLARE @name nvarchar(255) OPEN ShrinkAllDBs ? FETCH NEXT FROM ShrinkAllDBs INTO @name WHILE (@@fetch_status <> -1) BEGIN IF (@@fetch_status <> -2) BEGIN SET @sql = N'DBCC SHRINKDATABASE(N''' + @name + N''')' EXEC sp_executesql @sql END FETCH NEXT FROM ShrinkAllDBs INTO @name END ? CLOSE ShrinkAllDBs DEALLOCATE ShrinkAllDBs GO
已抢187058个
抢已抢67499个
抢已抢353732个
抢已抢668386个
抢已抢123790个
抢已抢25951个
抢