declare @tb_name as varchar(50);
declare @sql as varchar(200);
DECLARE cur_tb CURSOR FORWARD_ONLY for
SELECT NAME FROM sysobjects t WHERE t.xtype='U';
open cur_tb;
fetch next from cur_tb into @tb_name;
while @@FETCH_STATUS = 0
begin
set @sql='select top 5 * from '+@tb_name;
exec(@sql);
fetch next from cur_tb into @tb_name;
end
close cur_tb
deallocate cur_tb
SQL Server中查询所有表的前5条数据
本文介绍了一种使用T-SQL游标遍历数据库表名并动态执行SQL语句的方法。通过声明变量和游标,实现对数据库中所有用户表的查询,每次仅返回每张表的前五条记录。

被折叠的 条评论
为什么被折叠?



