SQL Server REVERSE()

SQL Server REVERSE Literal String

In this SQL Server tutorial, you will learn about the SQL Server REVERSE() function to change the order of the string value. This function is very helpful in the data manipulation of strings, such as creating unique codes, data formatting, etc. You will understand the syntax of the REVERSE() function with its definition, and then … Read more

CHECKSUM_AGG Function in SQL Server

Using CHECKSUM_AGG Function in SQL Server

In this SQL Server tutorial, You will explain the CHECKSUM_AGG function in SQL Server. With this function, you can perform data integrity checks. First, I will explain the ‘What is CHECKSUM_AGG() function?’ and its syntax, which describes how to use it. Afterwards, you will see how to check the data changes in a table using … Read more

SUBSTRING Function in SQL Server

SUBSTRING Function in SQL Server

In this SQL Server tutorial, you will learn about the SUBSTRING function in SQL Server. You can use this function to manipulate the string by extracting a specific part. First, you will be introduced to the definition of the SUBSTRING() function and its syntax. Then, with a simple example, you will understand how it works. … Read more

DATEDIFF Function in SQL Server

DATEDIFF Function in SQL Server Finding Year Difference Between Two Dates

In this SQL Server tutorial, you will learn about the DATEDIFF function in SQL Server. This function helps find the difference between two dates. You will understand the ‘What is DATEDIFF() function with syntax’, then see how the DATEDIFF() function works with an example. Ultimately, you will use the DATEDIFF() function on the tables to … Read more

CHARINDEX Function in SQL Server

Performing Case-Sensitive Search using CHARINDEX Function in SQL Server

In this SQL Server tutorial, you will learn how to find the position of the substring in the string using the CHARINDEX function in SQL Server. First, you will understand ‘what the CHARINEDX() function’ with its syntax, then the working of the CHARINDEX() function with an example. After that, you will understand how the CHARINDEX() … Read more

WHERE Condition in SQL Server

WHERE Condition in SQL Server with Equality Operator

In this SQL Server tutorial, you will explain the WHERE condition in SQL Server to filter the rows from the table. First, you will understand the ‘What is WHERE condition in SQL Server’ with syntax. Then, you will use different operators like equality, comparison, AND, OR, BETWEEN, and IN to filter the rows based on … Read more

YEAR Function in SQL Server

YEAR Function in SQL Server

In this SQL Server tutorial, you will learn about the YEAR function in SQL Server to retrieve the information from the database based on the year. First, you will understand the syntax of the YEAR() function, then where you can use the YEAR() function. Then, understand how the YEAR() function works with an example. After … Read more

MONTH Function in SQL Server

In this SQL Server tutorial, you will learn about the MONTH function in SQL Server, which helps categorise the information based on the month part of the date. You will understand the syntax of the MONTH() function and just a small example of where you can use this function. Then, apply the MONTH() function to … Read more

How to use VARP Function in SQL Server

VARP Function in SQL Server with DISTINCT Option

In this SQL Server tutorial, you will learn about the VARP Function in SQL Server, where you will learn how to compute the variance of all data using the VARP() function. When your dataset has duplicate values, it can create noise and lead to inaccurate analysis. This function will help you deal with such unwanted items. You will … Read more

How to use STDEVP Function in SQL Server

STDEVP Function in SQL Server Computing Standard Deviation

In this SQL Server tutorial, you will learn about the statistical STDEVP function SQL Server. This function helps determine the variability in your data or the information that you have stored in the table. First, you will understand the ‘What is STDEVP() function?’, then its syntax. After that, the standard deviation of data containing duplicate … Read more