连接数据库时能否执行多条语句?

fengmingbao

Set con=createobject("adodb.connection")
conset = "......................................."

con.open conset

If  con.state=0 Then
        msgbox"DB Connection Failed"
End If

Set rs=createobject("adodb.recordset")

sql="select * from TicketTbl where TicketI = "&TicketID&" and TicketV = "&TicketVersion&""

这里能否存在多条?如果能,怎么做? 谢谢

sunqiang1024

可以的，然后你声明多个结果集应该就行了