搜索数据库中记录总数的SQL语句是什么来着？

[tontongs]

如题~~~谢谢~~~

[diya]

select count(*) as allcount from tablename

[pp4u]

select count(*) from table

[tontongs]

怎么把返回的值在ASP中显示出来？

[diya]

select count(*) as allcount from tablename

<%=allcount%>

[lions911]

SELECT COUNT(*) AS Expr1
FROM News

response.write rs("expr1")

[diya]

set rz=server.createobject("ADODB.recordset")
sql="select count(*) as allcount from tablename"
set rz=conn.execute(sql)
response.write rz("allcount")

写错上面才对,不好意思。

[tontongs]

谢谢，lions911(--ASP--ASP.NET--)