UC知道这些语句能用一条循环来实现吗？
来源：百度知道 编辑：UC知道 时间：2024/06/06 16:00:57
set rs1=server.createobject("adodb.recordset")
sql1="select * from monkey1"
rs1.open sql1,conn,1,3
set rs2=server.createobject("adodb.recordset")
sql2="select * from monkey2"
rs2.open sql2,conn,1,3
set rs3=server.createobject("adodb.recordset")
sql3="select * from monkey3"
rs3.open sql3,conn,1,3
sql1="select * from monkey1"
rs1.open sql1,conn,1,3
set rs2=server.createobject("adodb.recordset")
sql2="select * from monkey2"
rs2.open sql2,conn,1,3
set rs3=server.createobject("adodb.recordset")
sql3="select * from monkey3"
rs3.open sql3,conn,1,3
可以做到`~
set rs1=server.createobject("adodb.recordset")
sql1="select * from monkey1,monkey2,monkey3"
rs1.open sql1,conn,1,3
set rs ="............."
for i=1 to 3
rs.open "select * from monkey"& i,conn,1,3
next
-_-..可以试一下