Using SQL aggregate functions ver

  Using SQL aggregate functions
  Category : Asp Scripts-components Database tools  
  Platform :  
  Price :  
  Developer: Rey Nunez  
  Version :  
  HomePage Address :  
  Demo URL :  
  Date added :  
  Download Link : Click to Download  
Script Description:
 

  


This is an online article, the author discusses about the SQL's aggregate functions which is ready along with a specific item which might be an expression or a field. While generating a Recordset object, the developers could implement these functions as a columnitem in a query. Average function, Count function, Min and Max functions and Sum functions are the rest of the topics covered in this article. The sample source code is ready with each function.

 

more Tag: functions, function, aggregate, aggregate functions, sql aggregate functions,

Also see ...


Update Records 1)    Update Records
 This is an online tutorial which guides the users to update records from database. It uses simple steps and followups to make easy for the users to update their own records from database. Sample source code is given in this tutorial for example....

Reuse ADO recordsets 2)    Reuse ADO recordsets
 Now the webmasters could reuse ADO recordsets in their new SQL statement, which is explained in this online article. The author explains about reusing these ADO recordsets with an example. The author also discusses about destroying the recordsets. The sample source code is also available in this article....

Formatted Output from ASP 3)    Formatted Output from ASP
 The main objective of this online tutorial is to print any set of database reports from the browser of the client. The author discusses about the working of MS Access, Acrobat Exchange, DataDynamic's Active Reports, Chili!soft's Chili!Reports, Crystal Reports and OmniForm Internet Publisher. At the end of this article the output display is presented. The entire sample source code for each task is given....

SQL Server Connection Pooling Myths 4)    SQL Server Connection Pooling Myths
 This article makes the web developers to understand the real essence of connection pooling. The first section of this article contains few objective questions regarding the connection pool. The author explains this by generating an ASP page with more connections. All the answers for each question is explained along with the graphical description one by one. The sample source code is also given along with this tutorial. In a nut shell, this article explains the connection pooling through ADO....

How to Recover a Table Deleted from an Access Database 5)    How to Recover a Table Deleted from an Access Database
 This is an useful tutorial for the application developers. You can learn how to recover the table that was deleted from the Access database with the help of this tutorial.This tutorial provides two methods for table recovery. Using Ctrl+z undo command you can recover the deleted table. This method works only if you haven't done any cut, copy and paste undo combination of actions before trying to restore the table. Alternative method is using the code provided with this tutorial for restorin...

Database Connection String using Microsoft Access Driver (DSN less) 6)    Database Connection String using Microsoft Access Driver (DSN less)
 Through this online article the author shows the entire Connection string access. The article covers about Text or CSV Connection String using MS Text Driver(DSN less), Database Connection String using MS Excel Driver(DSN less), Oracle Database Connection String using MS Oracle ODBC Driver(DSN less) and SQL Server Database Connection String using MS SQL Server Driver(DSN less). The sample source code for each connection is given in this article....

Using Data Shape to create hierarchical recordsets 7)    Using Data Shape to create hierarchical recordsets
 The main objective of this online tutorial is to show the webmasters how to build hierarchical recordsets with the help of data shaping. The main intention of using this data shaping is to spend less server memory. The author explains the entire process of this task along with the sample source code projected in this article....

Generic Combo Advantage 8)    Generic Combo Advantage
 At the end of this article the learners comes to understand about the usage of dynamic combo boxes. Further the author discusses about the parameters passed to this function. The main usage of this function is to add or edit data from a database. The author explains about making two different calls. The sample source code is much helpful for the beginners....

Showing data from a database 9)    Showing data from a database
 After reading this online article the webmasters can learn more about the procedures that help to show data from a database. The author explains this concept with an example in which the data from a table would be printed with columns. The sample source code is available for the beginner's reference....

Tic-Tic-Toe 10)    Tic-Tic-Toe
 This is multiplayer game engine developed using ASP. The games are created with VBScript programming language and more. There are few steps to develop the applications like Global variables, start page, game preparation manager and passive players’ room and few other programs are given for the use of web designers....

Use ASP to create an HTML table that supporting paging and sorting 1)    Use ASP to create an HTML table that supporting paging and sorting
 The author tells the simple procedures to be followed to generate an HTML table which would be ready for paging and sorting. The values from one column could be linked with another page is the main advantage. The entire sample source code is ready for the developer's reference....

Smart Publisher Pro 2)    Smart Publisher Pro
 This is an easy to use content management program that can add, edit or delete contents on the websites. This program supports multiple language and multiregional environments. Users are allowed to retrieve and index language including keywords, classes, categories etc. Admin features like, ability to add, edit or delete images, managing files, databases, presentation etc....

VSEmail 3)    VSEmail
 VSEmail is a simple SMTP email send component for Active Server Pages. Currently it does not support attachments or html. VSEmail was compiled using Delphi 5....

ActiveEmail SMTP E-mail Toolkit 4)    ActiveEmail SMTP E-mail Toolkit
 ActiveEmail provides an easy-to-use programming interface to SMTP e-mail communications. Use it to send e-mails automatically, or in batches, from applications, web servers, or from the command-line. Use this ActiveX component inside your ASP, ASP.NET, Visual Basic, Visual Basic .NET, Visual C++, Visual C# .NET or VBScript application/tool. Features multiple recipients, embedded attachments, RTF/HTML Formatting, authentication, RFC 822, RFC 1521, RFC 1522 protocols....

Lanap BotDetect for ASP - website security solution designed to prevent automated registrations 5)    Lanap BotDetect for ASP - website security solution designed to prevent automated registrations
 Server side CAPTCHA COM component that prevents automated registrations on your website. Fully customizable, 7 different algorithms, custom size and image format. Free trial, source code included, royalty free!...

Use ADO to Return a Summary Row 6)    Use ADO to Return a Summary Row
 After going through this online tutorial the webmasters can get the value of summary rows. Using ADO this process is very simple which is proved in this article. The author shows how this ADO returns the query results as multiple recordsets and further the author demonstrates the task of retrieving the summary rows by giving loop through recordset. The entire sample source code is ready for the developer's use....

LinkMax2 7)    LinkMax2
 LinkMAX 2 is an ASP link indexing script. Features include: Easy setup and installation, Listings display Title, Description and Date added, You can approve sites before they get listed, An admin page that will show you new pages that have not yet been approved....

Adelio Animated Classic Guestbook (ASP) 8)    Adelio Animated Classic Guestbook (ASP)
 Looking for a guestbook that will dazzle your visitors and that they will actually sign? Adelio Classic Guestbook features animated sequences for opening the book, page flipping and closing it. Password protected admin features. ASP and Flash skin source included....

Ticket based Support System 9)    Ticket based Support System
 Support System v. 1.02 One of the best and most useful tools for any company that requires more than one person for their operations. The support system is a very powerful tool that enables to follow a proccess, either an internal one, such as following a procedure, or an external, like customer support. It allows users to track each tickets, issue, sale or any process that involves more than one person or needs to be followed by anyone. Costumers will love to be able to see what is going...