数据库每个表中有几条记录

   DECLARE tables_cursor CURSOR
      FOR
      SELECT top 100 name FROM sysobjects WHERE type = 'U' order by name
   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 count(*) as ''' + @tablename + ''' from '+  @tablename)
      FETCH NEXT FROM tables_cursor INTO @tablename
   END
   DEALLOCATE tables_cursor