<% dim a,b,c set a=server.createobject("adodb.connection") a.open"driver={ sql server};server=gg;uid=ss;pwd=12331233;database=student" b="select top 100 * from 表 order by newid()" set c=server.createobject("adodb.recordset") c.open b,a ........%>
如果你要將隨機的100記錄按一定的次序返回: select * from (select top 100 * from yourTable order by newid()) as A order by yourField
楼上不用吧! select top 100 * from yourTable order by newid(),你的字段
dim a,b,c
set a=server.createobject("adodb.connection")
a.open"driver={ sql server};server=gg;uid=ss;pwd=12331233;database=student"
b="select top 100 * from 表 order by newid()"
set c=server.createobject("adodb.recordset")
c.open b,a
........%>
select * from
(select top 100 * from yourTable order by newid()) as A
order by yourField
select top 100 * from yourTable order by newid(),你的字段