Tag: SQL
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,...
SSRS - Report Builder: The first version of Report Builder was released by Microsoft in 2005. The product was advertised as a development and management tool with which end users and database...
Database quality analysis - To analyze the properties of databases, it is proposed to highlight the quality characteristics of the database management system and the information contained in it. It...
SQL Server Event Service - Quite often, developers of client-server applications need to organize a mechanism that allows the event on the sql-server to notify one or another client. Even more often...
Database Design - Widely known methods of designing databases (DB) have appeared in the course of development of more and more complex Information Systems (IS) which should consider requirements...