if object_id(N'tempdb.db.#') is not null
drop table #
create table #(id int identity ,tblname varchar(50),num int)
declare @name varchar(30)
declare roy cursor for select name from sysobjects where xtype='U'
open roy
fetch next from roy into @name
while @@fetch_status=0
begin
declare @i int
declare @sql nvarchar(1000)
set @sql='select @n=count(1) from ' + @name
exec sp_executesql @sql,N'@n int output',@i output
insert into # select @name,@I
fetch next from roy into @name
end
close roy
deallocate roy
select * from # order by num
Sqlserver数据库中查询所有表记录数据,最大表数据,最小表数据
最新推荐文章于 2024-04-11 15:09:55 发布