declare @sql nvarchar(800)
declare @tablename nvarchar(400)
declare @tname nvarchar(400)
declare @count int
declare @i int
declare @num int
select @num=count(*) from sysobjects where xtype='u'

set @i=1

while @i<=@num
begin
set @sql=N'select @tname = top 1 name from sysobjects where id not in (select top @number id from sysobjects order by id asc)'
select @sql
exec sp_executesql @sql,N'@tname char(400),@number int',@tablename,@i
set @sql=N'select @tname,count(*) from @tname '
exec sp_executesql @sql,N'@tname char(400)',@tablename

set @i = @i+1
end

想实现用户表名和记录数显示的，想不通哪错了，知道的帮俺纠正下错误。

如果只是取一个表的记录总数的话，这样子就可以了

select top 1 isnull(a.rowcnt,0) as total from sysindexes a left join sysobjects b on a.id=b.id where b.[name]='表名' and b.xtype='u'

楼上的代码效率高 但是有些投机取巧   假若权限不够访问系统表或数据库版本有变动..
发现一般的做法是自己加个表记录各表总数