Home
Submit
Source
Feeds

Home » ASP » Database Integration ::

Using SUM Function in An SQL Statement

ASP Database Integration
Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
Related Tutorials
ASP Date and Time
Using DateDiff function in SQL Statement
ASP / Date and Time
You may use DateDiff function in an SQL statement to get the number of date and/or time between two dates. You may calculate days between two different date.

Site: www.dotnetindex.com Report - View Tutorial

ASP Date and Time
Using GetDate Function in an SQL Statement
ASP / Date and Time
This function is very useful, if you wish to get date of current SQL server date and time. You may use this function to fill some rows automatically with current time or using with DateDiff function to return the number between current time.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
AddCriteria Simplifies SQL Queries
ASP / Database Integration
The AddCriteria function (listed later) elegantly encapsulates the logic to build an SQL statement by adding optional criteria only if the user posted data for a field.

Site: www.15seconds.com Report - View Tutorial

ASP Date and Time
Returning Month of Date in an SQL Table
ASP / Date and Time
This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a 'SELECT' sql statement.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
SQL: Sum,Average,Max,Min,Count,Detail
ASP / Database Integration
There are a great many statistics that you can perform on your data with simple sql. Sum, Average, Max, Min, and Count can be derived nearly as easy as showing the complete detail of your data.

Site: www.codeave.com Report - View Tutorial

ASP Database Integration
Fun With Stored Procedures
ASP / Database Integration
A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others ... A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates... as an added bonus, it further separates the sql statement from your asp leaving you with more readable code. So let's get on with it.

Site: www.aspemporium.com Report - View Tutorial

ASP Database Integration
Add records with sql statments
ASP / Database Integration
Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

Site: nuts4asp.com Report - View Tutorial

ASP Database Integration
Edit records with sql statements
ASP / Database Integration
Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

Site: nuts4asp.com Report - View Tutorial

ASP Database Integration
Getting Your Quotes Right In SQL For ASP
ASP / Database Integration
It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions.

Site: www.webdevelopersjournal.com Report - View Tutorial

ASP Database Integration
SQL In Simple English - Part II
ASP / Database Integration
This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.

Site: stardeveloper.com Report - View Tutorial

ASP Database Integration
Counting Records Wizard
ASP / Database Integration
Counting records in a database is easy to do with an sql statement in asp and vbscript.

Site: pacosdrivers.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL INSERT statement
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL INSERT statement
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL DELETE statement
ASP / Database Integration
In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Executing Transact-SQL UPDATE statement
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

 
Site Search

 
Categories
2D Graphics 3D Graphics Office Applications Databases Desktop Programming Web Development
 
Advertisement
 
Copyright © 2006-2008 TutCity.com | Submit Tutorials | Contact us | Terms of use | Privacy Policy