sql随机函数newID()和RAND()

sql server的随机函数newID()和RAND()　　

　　SELECT * FROM Northwind..Orders ORDER BY NEWID()

　　--随机排序

　　SELECT TOP 10 * FROM Northwind..Orders ORDER BY NEWID()

　　--从Orders表中随机取出10条记录