摘要:
--sp_helpdb--查看可用数据库 declare @name sysname, @sql nvarchar(4000)DECLARE roy CURSOR FOR --排除不分离的数据库名就行了SELECT name FROM sysdatabases where name not in ('master','tempdb','pubs','Northwind','msdb','model')open royFETCH NEXT FROM roy INTO @nameWHILE @@FETC 阅读全文