查询某个数据库中某个表中数据情况的一条语句

sp_msforeachtable 'select count(1) as ''?'' from ?  '

/*结果***********************
[dbo].[titleauthor]
-------------------
25

[dbo].[stores]
--------------
6

[dbo].[sales]
-------------
21

[dbo].[roysched]
----------------
86

[dbo].[discounts]
-----------------
3

[dbo].[jobs]
------------
14

[dbo].[pub_info]
----------------
8

[dbo].[employee]
----------------
43

[dbo].[sysGroup]
----------------
2

[dbo].[sysUser]
---------------
5

[dbo].[test]
------------
0

[dbo].[mo] 
-----------
0

[dbo].[mt] 
-----------
0

[dbo].[mtreport]
----------------
0

[dbo].[authors]
---------------
23

[dbo].[publishers]
------------------
8

[dbo].[titles]
--------------
18

******************************/