Tag: T-SQL

SQL Aggregate Functions
 

SQL Aggregate Functions

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...

SQL delete row - Operator DELETE
 

SQL delete row – Operator DELETE

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...

CONVERT - SQL Server function
 

CONVERT – SQL Server function

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
 

Sql cast – examples

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...

Functions COALESCE and ISNULL in T-SQL - features and main differences
 

Functions COALESCE and ISNULL in T-SQL – features and main differences

In the T-SQL language there are such functions as COALESCE and ISNULL, which can check the incoming parameters to the value of NULL, today we will consider the features of these functions, as...

Transact-SQL (TSQL)
 

Transact-SQL (TSQL): basics for beginners

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...

T-SQL language - Executing dynamic T-SQL instructions in Microsoft SQL Server
 

T-SQL language – Executing dynamic T-SQL instructions in Microsoft SQL Server

T-SQL is an extension of the SQL language that is used in Microsoft SQL Server. This section contains materials for learning Microsoft SQL Server and T-SQL language. This is one of my favorite...

 
4