Home » SQL Server

Tag Archives: SQL Server

SQL Server COALESCE() Function

Bipartite Graph

In this article, we will show you about SQL Server COALESCE() Function through detailed examples. 1. Introduction SQL is a standard language for storing, manipulating, and retrieving data in a database. SQL stands for Structured Query Language. SQL became a standard of the American National Standards Institute (ANSI) in 1986 and of the International Organization for Standardization (ISO) in 1987. ...

Read More »

5 Best Free Online SQL Formatter Tools

Bipartite Graph

1. Introduction The official meaning for the verb format is to convert a code from an initially defined style that you wrote into a standard generic format.SQL format tool will allow you to convert a “handwritten” SQL format into a pettier visual format to be more easily readable. The readability decreases direct proportional with the length of the query this will cost ...

Read More »

SQL EXISTS Operator

Bipartite Graph

1. Introduction The SQL EXISTS operator is a logical operator that is used to check whether a subquery returns any row. It returns TRUE if the subquery returns one or more rows, else it returns FALSE. SQL EXISTS operator syntax: WHERE EXISTS ( subquery ) In this example, I will demonstrate the following use cases: In a SELECT statement.In a ...

Read More »

SQL Server PIVOT Operator Explained

Bipartite Graph

1. Introduction SQL Server has supported the PIVOT operator since version 2005. It is used to generate a multidimensional report by transferring data from the row level to the column level. PIVOT Syntax SELECT <non-pivoted column>, [first pivoted column] AS <column name>, [second pivoted column] AS <column name>, ... [last pivoted column] AS <column name> FROM (<SELECT query that produces ...

Read More »

SQL Server FORMAT() Function

Bipartite Graph

1. Introduction SQL Server provides a format function that returns a formatted value based on the specified format. It is very useful as different countries have different formats for the number, date, and currency. Here is the syntax for the Format function: FORMAT Syntax FORMAT( value, format [, culture ] ) It returns a formatted string and has three arguments: ...

Read More »

SQL Server REPLACE() Function

Bipartite Graph

1. Introduction SQL defines the REPLACE function which takes three required arguments and returns a new string in which all occurrences of the substring are replaced by a new substring. REPLACE(input_string_arg, searching_substring_arg, replacing_substring_arg) input_string_arg – required, the searching source data.searching_substring_arg – required, the substring to be replaced.replacing_substring_arg – required, the replacement substring to be used to replace the searching_substring_arg. Note: ...

Read More »

SQL Server Tutorial for Beginners (Video)

Bipartite Graph

This is a tutorial about SQL Server for beginners. You can also check this tutorial in the following video: SQL Server Tutorial for Beginners – video 1. What is SQL Server SQL Server is a relational database management system (RDBMS) developed by Microsoft. The primary function of the SQL Server is to store and retrieve data used by other applications ...

Read More »

Download and Install SQL Server Management Studio

Bipartite Graph

In this article, we’re going to the steps to download and install the Microsoft SQL Server Management Studio (SSMS). 1. SSMS System Requirements SQL Server Management Studio (SSMS) is a powerful application maintained and distributed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server. The application was first launched with Microsoft SQL Server 2005 ...

Read More »

SQL Server Versions

Bipartite Graph

In this article, we’re going to see several Microsoft SQL Server versions and editions and how to identify them. 1. Introduction On MSSQL Server we need to determine the version and edition to troubleshoot some issues or to know if feature support is available. To do that, MSSQL Server introduces some procedures to identify the version and edition which we’re ...

Read More »

SQL Server 2019: Overview and Installation

Bipartite Graph

1. Introduction In this tutorial, we will see some new and key features of SQL Server 2019 and we will write a small example to help you get started. 2. What’s new in SQL Server 2019 2.1 Intelligent Query Processing Enhancements This is a set of enhancements that improves Query Optimizer. Query Optimizer is a component inside SQL Server that ...

Read More »