这个其实不算原创的，是网友闲心＂游僧 问我的一个SQL问题，解决了，感觉挺有意思就贴上来了。

declare @tableName varchar(30)
declare @tableRowCount int
declare @strSql varchar(320)
declare @ResultTable table(rowsCount int, tablesName varchar(40))
declare @strCount varchar(100)
declare myCur cursor for (select name from sys.objects where type='U')
open myCur
fetch next from myCur into @tableName
while @@fetch_status = 0
    begin
   set @strSql=' select COUNT(*) as tCOUNT,'''+@tableName+''' as tableName from '+ @tableName
--   exec(@strSql)
   insert into @ResultTable exec(@strSql)
   fetch next from myCur into @tableName
end
close myCur
deallocate myCur
select * from @ResultTable;