数据库表A中随机X条数据满足N条件的数据安插到表B中

分类: IT文章 • 2024-12-06 18:29:42

数据库表A中随机X条数据满足N条件的数据插入到表B中

select * into c FROM a TABLESAMPLE (5 PERCENT)

select top 5 per * into c from a order by newid()

select top 5 * into c from a where id<10 order by newid()