with TableRecord(TableName,RecordCount) as
(
select o.name,i.rows
from sysobjects o,sysindexes i
where o.id=i.id and o.Xtype='U' and i.indid<2
)
select * from TableRecord order by tablename
with TableRecord(TableName,RecordCount) as
(
select o.name,i.rows
from sysobjects o,sysindexes i
where o.id=i.id and o.Xtype='U' and i.indid<2
)
select * from TableRecord order by tablename