摘要:
--drop table #dbfiles--deallocate cursor1------declare cursor1 cursor for SELECT name from sys.databases-- 临时表CREATE TABLE #dbfiles( dbname nvarchar(100),filetype nvarchar(100),filename nvarchar(200))declare @name varchar(100) --数据库名declare @sql nvarchar(1024) --临时sql 语句open cursor1fetch next from.. 阅读全文