sysobjects
我想查出数据库A里面所有的表及表的数据条数？怎么用SQL语句写出？
谢谢！
-----------------------
CSDN 论坛助手
http://china-csdn.cn

[解决办法]
create table AAA(id int identity(1,1),tablename varchar(50),[rowcount] int)

delete from AAA

exec sp_msforeachtable 'insert AAA(tablename, [rowcount]) select N ' '? ' ', count(*) from ? '

select * from AAA