使用newid()随机选择多行,可以使用newid()函数,newid()函数用来产生guid,你也可以
insert into test1 values(newid())
SELECT *FROM Northwind..Orders ORDER BY NEWID()
SELECT TOP 10 * FROM Northwind..Orders ORDER BY NEWID()