选择数据库中每个表的前 3 行 [英] Select the first 3 rows of each table in a database

问题描述

我有一个包含 69 个表的数据库，我只想选择每个表的前三个记录.

I have a database with 69 tables and I want to select only the first three records of each table.

我可以每张桌子这样做:

SELECT TOP 3 * 
  FROM table_schema.table_name

但是，如果我要手动执行此操作，则会花费很多时间.

However if I was to do this manually, it would take a lot of time.

你能提出一个解决方法吗?

Could you please suggest a workaround?

我尝试了这个解决方案 但我可以让它工作(我不知道如何为 MSSQL 修改它)

I tried this solution but I can get it to work (I don't know how to modify it for MSSQL)

编辑感谢您的回复.我可能还不够清楚:我的意思是我想解析每个单独的表，只获取前 3 条记录，然后再转到下一个.Yaroslav 下面的代码正是我需要的

EDIT Thanks for your replies. I probably wasn't clear enough: I meant I wanted to parse each individual table and only get the top 3 records than move on to the next one. Yaroslav's code below is what I needed

DECLARE @sql VARCHAR(MAX)='';
SELECT @sql=@sql+'SELECT TOP 3 * FROM '+'['+SCHEMA_NAME(schema_id)+'].['+name+']'+';'
  FROM sys.tables
EXEC(@sql)

推荐答案

这里有:

DECLARE @sql VARCHAR(MAX)='';
SELECT @sql=@sql+'SELECT TOP 3 * FROM '+'['+SCHEMA_NAME(schema_id)+'].['+name+']'+';'
  FROM sys.tables
EXEC(@sql)

这篇关于选择数据库中每个表的前 3 行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！