create table #T([name] varchar(100),type_desc varchar(10),[size] float)
EXECUTE sp_msforeachdb
'insert into #T([name],type_desc,[size])
select [name],type_desc,[size] from [?].sys.database_files'
select * from #T
drop table #T
转载于:https://www.cnblogs.com/lfzwenzhu/archive/2010/10/11/1847602.html
