Author: Délio Damin

A view is an alternative solution for observing data from one or more of the tables comprising a database. You can regard it as a virtual table or a stored…

Triggers are a type of special stored procedures that are executed whenever there is an attempt to change the data in a table protected by them.  DML triggers (Data Manipulation…

A stored procedure is a set of instructions developed in T-SQL language (Transact-Sql) that, whenever stored or saved, are inside the server in a pre-compiled way. This procedure is stored…

The main task in a Database manager is to not just make sure all data is inserted, but also that these data continue existing. Regardless of the contingency system, the…

This article illustrates a few SQL commands. To illustrate how they are used, the following tables will work as reference: Store_Information table: Store_Name    Sales    Date_Time Los Angeles    1500     05-Jan-1999…

Every SQL Server database has at least two operational system files: a data file and a log file. The data files contain both data and objects, such as tables, indexes,…

Historics are the modules responsible for storing application data in a Database for further analysis. You can create as many Historics as needed, each containing several Tags or expressions. Each…

This is the introduction to a series that will discuss SQL, the widely known language used for relational databases. The Structured Query Language (SQL), a very popular one for interacting…

Basically, information can be manipulated in the Database in three different ways: DML – Data Manipulation Language Statements: INSERT, UPDATE, DELETE, SELECT DDL – Data Definition Language Statements: CREATE, ALTER,…