This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example.

In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database.

In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database

This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement using ASP.

Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.

We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.

In this short ASP source code, we will pull some data from a database and fill it into a select list. We will create a custom and dynamic output.

In this short ASP source code, we will pull some data from a database and fill it into a select list. We will create a custom and dynamic output.

This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.

Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.