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

Source: Internet
Author: User
Tags table name

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")

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.