Question

ASP里,用什么办法查出数据库里有多少条数据?

ASP里,用什么办法查出数据库里有多少条数据? 再将数据库里的条数传递给 num
不能用循环语句

Answer 1

sql="select count(*)cnt from 表"
rs.open sql,conn
num=rs("cnt")

sql="select * from 表"
rs.open sql,conn,1,1
num=rs.recordcount

Answer 2

set rs=server.createobject("adodb.recordset")
sqlStr="select count(*) as num from tablename"
rs.open sql,conn,1,1
num=rs("cnt")

Answer 3

rs.open "select count(*) from usertable",conn,1,1
num=rs(0)

Answer 4

<%
num=0
do while not rs.eof
num=num+1
rs.movenext
loop

%>

Answer 5

num=rs.recordcount