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