在sql server 2005/2008中的当前数据库中遍历所有表显示所有表的行数 sql server declare counttablerecords cursor read_only for select sst.name, schema_name(sst.schema_id) from sys.tables sst where sst.type = 'u' declare @name varchar(80), @schema varchar(40) open counttablerecords fetch next from counttablerecords into @name, @schema while ( @@fetch_status -1 ) begin if ( @@fetch_status -2 ) begin print @name declare @sql nvarchar(1024) set @sql='declare @count int select @count=count(1) from ' + quotename(@schema) + '.' + quotename(@name) +' print @count' exec sp_executesql @sql end fetch next from counttablerecords into @name, @schema end close counttablerecords deallocate counttablerecords go