Tag: Microsoft SQL Server
SQL Server operator ORDER BY is used to sort records in the SELECT query result set. Syntax for ORDER BY statement in SQL Sorting by one field:SELECT * FROM tab n WHERE condition ORDER BY...
SQL Server the most popular database management systems (DBMS) in the world. This DBMS is suitable for a variety of projects: from small applications to large highly loaded projects.SQL...
IDENTITY SQL - The table property in Microsoft SQL Server is IDENTITY_INSERT. Using this property, we can insert an explicit value into the autoincrement column with IDENTITY that was previously...
Microsoft SQL Server 2012 - a fully ready-to-use information platform in the cloud, which provides confidence in the reliability of business-critical systems when working with data and...
SQL server ports - The subsystems and components that Microsoft continues to complement SQL Server have significantly increased the number of network connections used by the platform....
SQL IIF function of T-SQL language, which is designed to simplify the writing of conditional constructions using the well-known expression CASE or operators IF...ELSE...THEN.IIF is a logical...
SQL Server Connection String - method of determining the database connection string. Using this line the application (program) can access the database elements (tables, views, charts,...
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....
Microsoft Exchange server is an email forwarding service. It supports client protocols such as POP3, SMTP, MAPI and IMAP. It integrates with Outlook.This program is used if you want to allow...
Microsoft Windows Server 2012 - After four years of development, on September 4, 2012, Microsoft announced the availability of a new version of Windows Server.Historically, the operating...
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...
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,...