--
得到数据库中所有表使用的空间
user ProductManagement
declare @sql varchar ( 8000 )
set @sql = ' '
select @sql = @sql + ' exec sp_spaceused ''' + name + ''' ' from sysobjects where xtype = ' u '
-- set @sql = left(@sql,len(@sql) - 10) + ')a'
exec @sql
user ProductManagement
declare @sql varchar ( 8000 )
set @sql = ' '
select @sql = @sql + ' exec sp_spaceused ''' + name + ''' ' from sysobjects where xtype = ' u '
-- set @sql = left(@sql,len(@sql) - 10) + ')a'
exec @sql