参考下列方法可以获得每个表格的数据数目。
USE pubs -- 可改成您的数据库名称 SET NOCOUNT ONDECLARE tables_cursor CURSOR FOR SELECT name FROM sysobjects WHERE type = 'U' OPEN tables_cursor DECLARE @tablename varchar(30), @quote char(1) SELECT @quote = '"'
FETCH NEXT FROM tables_cursor INTO @tablename WHILE (@@fetch_status <> -1) BEGIN EXEC ("Select " @quote "Rows in " @tablename " = " @quote ", count(*) from " @tablename) FETCH NEXT FROM tables_cursor INTO @tablename END DEALLOCATE tables_cursor SET NOCOUNT OFF