数据库所有表中数据行数统计

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TableSpace]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TableSpace]
go

create table TableSpace
(
 TableName  varchar(200),
 RowsCount char(50),
 Reserved varchar(50),
 Data  varchar(50),
 Index_size varchar(50),
 Unused  varchar(50) 
)
go

declare @sql varchar(1000)
declare @TableName varchar(100)

declare Cursor1 Cursor
for
 select name from sysobjects where xtype='U'

open Cursor1
fetch next from Cursor1 into @TableName

while @@fetch_status = 0
begin
 set @sql = 'insert into TableSpace '
 set @sql = @sql + ' exec sp_spaceused '''+ @TableName + ''' '
 exec (@sql)
 fetch next from Cursor1 into @TableName
end
close Cursor1
deallocate Cursor1
go

--select * from TableSpace