随机产生100条记录

select   top   100   from   表   order   by   newid()

===================

select top n * from tablename order by newid()

原文地址:https://www.cnblogs.com/moss_tan_jun/p/1860866.html