Home Forums SQL Server 7,2000 Administration Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname
ronaldriveros
Valued Member
Points: 67
More actions
May 4, 2016 at 1:14 pm
#1876715
create table #t (i int)EXEC sp_MSForEachTable 'insert into #T select count(*) from ?'select sum(i) from #t
create table #t (i int)
EXEC sp_MSForEachTable 'insert into #T select count(*) from ?'
select sum(i) from #t