Tutorials

This tutorial are for those who had a background in Emgu CV and for those who are new in EmguCV visit this link: http://www.emgu.com/wiki/index.php/Download_And_Installation

Emgu CV is a cross platform .Net wrapper to the Intel OpenCV image processing library.Allowing OpenCV functions to be called from .NET compatible languages such as C#, VB, VC++, IronPython etc. OpenCV (Open Source Computer Vision) is a library of programming functions for real time computer vision.Unlike other wrappers such as OpenCVDotNet, SharperCV or Code Project which use unsafe code, Emgu CV is written entirely in C#. The benefit is that it can be compiled in Mono and therefore is able to run on any platform Mono supports, including Linux, Solaris and Mac OS X.

The DROP statement is used to delete object in SQL, with the DROP statement we can remove index, tables and even databases easily.

DROP INDEX

The indexes of the table can be dropped by the using the following command.

SYNTAX for MS Access

The MID() function is used to extract values from a column. The MID() contain three (3) parameters. The first one is used to select which column to extract, the second one is the starting position, the last one is the number of characters to be extracted.

SQL MID() Syntax

The AVG function calculates the average of a specified column. It works only on a numeric column. It first sums up all data and then divides it by the total number of rows.For example if the sum of 5 items is 10 then average is 10/5 = 2.

SQL AVG() Syntax

The FIRST function returns the first value of the selected column. FIRST function is not standard SQL function so it cannot be used with other DBMS like MySQL. However this is very useful with MS Access OR SQL Server.

SQL FIRST() Syntax

The MAX function is use to return the largest value of the selected column. MAX can be use only in numeric column.

As with other function, you can also give an Alias to the MAX function.

SQL MIN() Syntax

The MIN function is use to return the smallest value of the selected column. MIN can be use only in numeric column.

As with other function, you can also give an Alias to the MIN function.

SQL MIN() Syntax

The SUM function is an aggregate function use to calculate the total amount of a column. SUM function can be use only in numeric column.

Syntax

The NOW() function is an aggregate function used to return the date and time along with other column.

The NOW() function returns the result as dd/mm/yyyy HH:MM:SS AM/PM depending on your regional settings.

SQL NOW() Syntax