脚本查询 SQL数据库 各个表的 记录数

declare   @tbName     nvarchar(500) 
declare   @ct      int    
declare   @csql   nvarchar(500)    
declare   #tb   cursor   for  SELECT OBJECT_NAME (id) As TableName FROM sysobjects WHERE xtype = 'U' AND OBJECTPROPERTY (id, 'IsMSShipped') = 0
open   #tb  
 fetch   next   from   #tb   into   @tbName
 while   @@fetch_status=0  
 begin   
  set @csql = N'Select @ct= Count(*)  From ' + @tbName
  Exec dbo.sp_executesql  @csql,N'@ct   int   output',@ct   output  
  Print @tbName + '---' + Cast(@ct  As  nvarchar(500))  -- 这里可以修改一下，打印出来，或者插入到临时表中都可以
 fetch   next   from   #tb   into   @tbName
 end      
close   #tb  
deallocate   #tb