ASP随机读取N条记录
网络整理 - 09-04
以读取10条记录为例,代码如下:<%
randomize
sql="select top 10 name,time,id,url,filename from art_body where ischeck=1 order by rnd(-(id+"&rnd()&")),time desc"
......
%>
<%
randomize
sql="select top 10 name,time,id,url,filename from art_body where ischeck=1 order by rnd(-(id+"&rnd()&")),time desc"
......
%>