Method for obtaining the return value of the SELECT Count statement in ASP

This article mainly introduced the ASP to obtain the SELECT Count statement return value method, generally uses in the statistical data use the SELECT Count statement, obtains the query to the row number, needs the friend to be possible to refer to under

We use the Select COUNT (*) statement when we generally count database records, and when we use Query Analyzer for SQL Server, the direct input to the SELECT count (*) from table name counts the records in the table. But how do we return the value when we use ASP to implement it? That is, how to output the total number of recorded records? Please keep looking down.

In fact, we just give the query results of SQL statements to solve the problem, and then use the ASP statement output this alias, the relevant code is as follows:

The code is as follows:

Set Rs=conn. Execute ("Select Count (*) as" total ' from table ')

Response.Write RS ("Total")