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