con="数据库连接字符串"
set cn=server.createobject("adodb.connection")
cn.open con
set rs=server.createobject("adodb.recordset")
sql="select * from table"
rs.open sql,cn,1,3
numtt=rs.recordcount
if numtt>30 then
i=1
do while not rs.eof
if i>30 then
sql="delete from table where ID=rs("id")"
cn.execute(sql)
end if
rs.movenext
i=i+1
loop
end if