SQL tutorial
AVG function (Average) in SQL Server (Transact-SQL) - AVG function returns the arithmetic mean for all found records. Arithmetic mean of a group of numbers is their sum divided by their...
Terminal server - a device that provides remote access to the desktops and delegates computing resources to the end user. It is used with specialized software that supports the ability to work...
INSERT INTO - is a T-SQL instruction designed to add data to a table, i.e. create new records. This instruction can be used both for adding one line to the table and for mass inserting data....
The CREATE TABLE instruction in SQL Server creates a new database table with all relevant columns of the required data type. The following is the basic form of the CREATE TABLE manual:CREATE...
MERGE SQL - In Transact-SQL language in one row with such operations as INSERT (insert), UPDATE (update), DELETE (delete) is the operation MERGE (merge), which in some cases may be useful, but...
The INSERT SQL statement is used to insert one or more records into a table. There are two syntaxes for the INSERT statement depending on whether you are inserting one record or more...
In SQL Server (Transact-SQL), the CHARINDEX function returns the substring location in a string. The search is case insensitive.Syntax of the CHARINDEX function in SQL Server...
SQL Aggregate functions exist in order to be able to generalize the obtained data in any way, i.e. to manipulate them as we want.These functions are performed using keywords that are included...
The DELETE command removes rows from a table or the main database table view, for example, in MySQL, Oracle. In this article you will learn how to use the DELETE statement, with syntax and...
SQL CONVERT - In this article you will learn how to use CONVERT function in SQL Server (Transact-SQL) with syntax and examples. Description OF THE SQL CONVERT FUNCTION In SQL Server...
Sql cast: in SQL language implementations the implicit type conversion can be performed. For example, in SQL Server and Sybase ASE. Transact-SQL when comparing or combining values of smallint and...
How do I use the CASE function in SQL Server (Transact-SQL)? In SQL Server (Transact-SQL) CASE operator has functionality of IF-THEN-ELSE operator. You can use a CASE statement in an SQL...
The DATEDIFF SQL Server function allows to calculate the difference between two values of date and time in units of a certain element (i.e. year, month, day), it takes into account only a certain...
The SQL SUBSTRING function cuts out and returns the specified number of characters from the string.SQL-function SUBSTRING can be used in Delphi applications working with queries to local SQL, but...
Transact-SQL (TSQL) directory will look like this, first I will give a small table of contents with navigation, then the directory itself will start, on each item will be comments, explanations and...
If you want to become a data processing and analysis specialist, you cannot do without SQL. This language can be used not only by analysts or scientists, but also by anyone who can spend several days...