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.
Similar scripts
A real easy way to add tables: ADOX
(Popularity: ) : After going through this online article, the webmasters can add tables to their database without any loss of data in an easy way by using ADOX. The author demonstrates how to insert the particular information into an ASP and can ... How To Retrieve XML Data in ASP with the XML OLE-DB Simple Provider
(Popularity: ) : The author explains about generating an ASP client which shows the OLEDB Simple Provider for XML to access XML data. The author describes about the task carried out by OLEDB Simple provider. With the help of standard methods of the ... Add Records With SQL Statments.
(Popularity: ) : 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 ... EZ update
(Popularity: ) : This is an useful tutorial in content management system where the author focusses mainly on webpage content authorizing. You can learn to make use of VBscript in editing and updating webpage contents from a text file. The author has explained ... Add a new record to a database
(Popularity: ) : This is an useful tutorial for all the users who need to add the values to the database table. This tutorial shows you how to create the database connection as well as the recordset object and how to add the ... Access Databases(DSN vs DSN-LESS)
(Popularity: ) : Now the developers could come to a decision about accessing databases with or without DSN. The main usage of a DSN LESS connection is to increase the performance and speed. The example provided by the author helps the webmasters to ... Use ASP to create an HTML table that supporting paging and sorting
(Popularity: ) : 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 ... Connections and Server Database
(Popularity: ) : This tutorial guides the users in a friendly way making connections with database server and also it helps them to make permissions to access database using System DSN's. This article gives briefly definitions for each topic like how permissions are ... Connections And Server Database Permissions
(Popularity: ) : The author of this article describes about the SYSTEM DSN and DSN LESS Connections. The author also suggests that, the process can be implemented only with Access database. In the final part the author describes about how the permissions are ... Using GetDate Function in an SQL Statement
(Popularity: ) : This article is helpful for the database administrators which gives them solution for accessing the date and time of SQL server using GetDate function in an SQL statement. Syntax for this function has been given to test on their web ...
User reviews
Similar Software
SQLRegEx: SQL Server Regular Expressions
(Popularity: ) : SQLRegEx adds regular expression capabilities to Microsoft SQL Server 2000. With regular expressions, a person skilled in Transact-SQL can perform a vast number of data manipulation tasks which previously would have required complicated code using T-SQL string functions, or a ... MSISQL (ISQL for Microsoft SQL)
(Popularity: ) : MSISQL (Interactive SQL for MSSQL) is a database administration solution for managing Microsoft SQL databases. It allows to build SQL queries using SQL Editor with SQL syntax highlighting and SQL Query History features; build SQL queries using Visual QueryBuilder; automate ... pgISQL (Interactive SQL for PostgreSQL)
(Popularity: ) : Interactive SQL for PostgreSQL is a powerfull database utility. It allows: Build SQL queries using SQL Editor with SQL syntax highlighting and SQL Query History features; Build SQL queries using Visual QueryBuilder; Automate routine tasks using ISQL for PostgreSQL in ... SQL Data Examiner 2010 R2
(Popularity: ) : SQL Data Examiner 2010 R2 is a tool for SQL compare and synchronization, supporting SQL Server, Oracle, MySQL, SQL Azure, Access databases. It greatly simplifies the process of data comparison and migration. Data returned by SQL queries can be compared ... SQL Buddy
(Popularity: ) : Automatically create SQL scripts to insert default values into tables with this easy to use program. Set your connection, choose your tables and click Create Script. It's as easy as 1,2,3! After using SQL Buddy you'll wonder how you ever ... SQL Buddy Lite
(Popularity: ) : Automatically create SQL scripts to insert default values into tables with this easy to use program. Set your connection, choose your tables and click Create Script. It's as easy as 1,2,3! After using SQL Buddy you'll wonder how you ever ... SwisSQL - SQL Server to Oracle Migration Tool
(Popularity: ) : SwisSQL - SQL Server to Oracle Edition is an Automated Migration tool to convert stored procedures implemented in Microsoft SQL Server Transact SQL into equivalent Oracle PL/SQL code. It automates more than 80% of the Transact SQL code conversion into ... STEnum.Framework for Mac
(Popularity: ) : STEnum.Framework, is an embedable Objective-C framework that adds SmallTalk style enumerations (collect, select, reject, detect, inject) to Cocoa collection classes (NSArray, NSDictionary, NSSet). To accomplish this, you pass function pointers to these methods.
This approach becomes very convenient and flexible using ... XLReportGen
(Popularity: ) : XLReportGen is a report generator for Microsoft Excel that outputs reports in Microsoft Excel spreadsheet format. If you know how to use Microsoft Excel and write SQL statements, you can use XLReportGen to create all kinds of reports as you ... XL Report Builder
(Popularity: ) : The Program XL Report Builder is a powerful and flexible tool for creating reports of any level of difficulty in the form of the Microsoft Excel Book. XL Report Builder allows to extract data simultaneously from several databases and to ...
Script Library
) : After going through this online article, the webmasters can add tables to their database without any loss of data in an easy way by using ADOX. The author demonstrates how to insert the particular information into an ASP and can ...