select top 10 * from tablename order by NEWID()
--生成随机时间
SELECT CONVERT(VARCHAR,CONVERT(DATETIME,100/RAND(),120),120)
select top 10 * from tablename order by NEWID()
--生成随机时间
SELECT CONVERT(VARCHAR,CONVERT(DATETIME,100/RAND(),120),120)
转载于:https://www.cnblogs.com/taomylife/p/5702931.html