本文通过一个SQL Server动态游标的示例介绍了如何遍历数据库中的所有表，并获取每个表的记录数。该过程使用了T-SQL声明变量、游标及执行动态SQL等技术。
declare @tablename varchar(100)
declare @sql nvarchar(4000)
declare @Num int
declare tb_cursor scroll cursor for select name from sysobjects where xtype='U'
open tb_cursor
fetch next from tb_cursor into @tablename
while @@fetch_status=0
begin
set @sql=N'select @Num=count(1) from '+@tablename
exec sp_executesql @sql,N'@Num int out',@Num out
if @Num>0 print @tablename
fetch next from tb_cursor into @tablename
end
close tb_cursor
deallocate tb_cursor
declare @sql nvarchar(4000)
declare @Num int
declare tb_cursor scroll cursor for select name from sysobjects where xtype='U'
open tb_cursor
fetch next from tb_cursor into @tablename
while @@fetch_status=0
begin
set @sql=N'select @Num=count(1) from '+@tablename
exec sp_executesql @sql,N'@Num int out',@Num out
if @Num>0 print @tablename
fetch next from tb_cursor into @tablename
end
close tb_cursor
deallocate tb_cursor
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
