你的位置:首页 > 数据库

[数据库]数据库表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()