求怎样得到数据库中某个表的总记录条数的语句?

详细点.还有怎样显示出来总条数

set conn=server.createobject("adodb.connection")

set rs=server.createobject("adodb.recordset")

conn.open "连接数据库字符串"

rs.open "select count(*) as recordcount from tablename",conn,1,1

response.write rs("recordcount")