sql随机排序
时间:2011-04-18 来源:海乐
Order By Rnd()
或
Order By NewID() ‘此句在sql2000中试好用
或
Select * From table Order By Rnd(ID)
或
SELECT * FROM table ORDER BY Rnd(ID-timer())
相关阅读 更多 +
时间:2011-04-18 来源:海乐
Order By Rnd()
或
Order By NewID() ‘此句在sql2000中试好用
或
Select * From table Order By Rnd(ID)
或
SELECT * FROM table ORDER BY Rnd(ID-timer())