即程序做如下调整就行了. strsql = "select * from movie_infos where m_idnum >384 order by newid()" set rs=conn.execute(strsql) while not rs.eof and not rs.bof sqlupdate = "update movie_infos set m_downloadnum =" & m_downloadnum & " WHERE m_idnum="&rs("m_idnum") conn.execute(sqlupdate) rs.movenext wend
strsql = "select * from movie_infos where m_idnum >384 order by newid()"
set rs=conn.execute(strsql)
while not rs.eof and not rs.bof
sqlupdate = "update movie_infos set m_downloadnum =" & m_downloadnum & " WHERE m_idnum="&rs("m_idnum") conn.execute(sqlupdate)
rs.movenext
wend
select top 100 * from 表 order by newid()