请问怎样统计我的库中的记录总数，先谢谢了

[tangchengze]

请问怎样统计我的库中的记录总数，先谢谢了

[swordman123]

<%=Rs.RecordCount%>

[ljupin]

Select Count(*) as aa From Table

[61]

Select Count(*) as num From Table
或
sql="select * from table"
rs.open sql,conn,1,3
num=rs.recordcount

[wang7655]

Select Count(*) as TOTAL_COUNT From Table

这个TOTAL_COUNT 就是记录的总数！

[xf_david921]

rs.recordcount
好用些

[icech]

sub Total()
dim sqlTotal
dim rsTotal
sqlTotal="select Count(*) from info"

Set rsTotal= Server.CreateObject("ADODB.Recordset")
rsTotal.open sqlTotal,conn,1,1
if rsTotal.eof and rsTotal.bof then
totalPut=0
response.write "共有 0 篇文章"
else
totalPut=rsTotal(0)
response.Write "共有 " & totalPut & " 篇文章"
end if
rsTotal.close
set rsTotal=nothing
end sub

用的时候
call Total()

[alan815]

select count(*) as num frome table

[chenxiaoqiang]

最好用rs.recordcount
速度比较快，而且方便◎◎

[soybean217]

最好用:
''''''''''''''''''
set rs=server.createObject("ADODB.recordset")
sql="select count(*) from table"
set rs=conn.execute(sql)
response.write(rs(0))
''''''''''''''''''
sql的执行速度绝对比ado的快

[tangchengze]

谢谢各位

[feren]

建议rs.recordcount

[dafei0320]

这里必须使用adOpenStatic或adOpen-Dynamic游标类型，而不能使用前向游标，否则会使RecordCount等属性或方法返回的值不正确!!
再用rs.recordcount

[feihu303]

用rs.recordcount最方便

[yzwxjun]

Select Count(*) as num From Table
或
sql="select * from table"
rs.open sql,conn,1,3
num=rs.recordcount

[ryuginka]

推荐
Select Count(*) as num From Table
最好不用recordcount