SQL 笔记

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

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

  --随机排序

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

posted @ 2011-07-25 14:59  胆小猫  阅读(77)  评论(0编辑  收藏  举报