SQL Server Blog
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...
Postgresql vs MySQL: MySQL is the most popular relational DBMS, while PostgreSQL is the most advanced and functional. Functions of DBMS MySQL and PostgreSQL Almost any developer will say that...
Oracle Database is an Oracle object-relational database management system. Oracle Database is the world's first DBMS designed specifically for working in the cloud. It introduces for the first...
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...
SQL COALESCE - a function that returns the first defined, i.e. non-NULL value from its argument list. Usually one or more COALESCE function arguments is the column of the table the query is...
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...
Windows server 2019 - About 10 years ago, Microsoft adjusted its operating system release ideology so that the latest Windows Server operating system would always be structurally similar to its...
Oracle SQL - Oracle DBMS is a relational database management system developed by Oracle Corporation.Oracle is the most popular of SQL implementations; it was historically the first commercial SQL...
Microsoft SQL Server 2017 - the new version of SQL Server is released in the same editions as the previous Microsoft SQL Server 2016.Enterprise - the most comprehensive release, includes all...
Microsoft SQL Server 2016 - is a relational database management system developed by Microsoft. As you know, support for SQL Server 2005 ended in April 2016 and currently there are the following...
SQL Server 2014 - Microsoft SQL Server is a database management system, or in short DBMS, which was developed by Microsoft and Sybase. It allows you to effectively manage databases of different...
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...
Microsoft SQL Server Analysis Services (SSAS) provides interactive analytics processing (OLAP) and intelligent data analysis functions for business intelligence applications. Analysis Services...
SSIS: Microsoft SQL Server includes the SQL Server Integration Services component, and today we will learn what this component is for and take a look at its main features.As you probably know,...