Microsoft SQL Server Tutorials
In this SQL Server tutorial, I will explain how to use the STUFF function in SQL Server, which helps in string manipulations. I will begin to describe the ‘What is STUFF() function?’ with syntax, and with examples, you will understand how it manipulates the string. Then, you will use the STUFF() function to format the … Read more
In this SQL Server tutorial, you will understand how to manipulate the string using the TRIM function in SQL Server. Here, using the TRIM() function, you can clean the string that contains unnecessary characters or remove spaces from the string. First, you will learn ‘What is the TRIM() function?’ with syntax. For example, I will … Read more
In this SQL Server tutorial, I will explain the SPACE function in SQL Server, which helps generate spaces. First, I will describe the SPACE function in SQL Server with an example, then the syntax of this function. After this, several examples to clear your concept of how the SPACE() function works. While doing this example, … Read more
In this SQL Server tutorial, you will learn about the DIFFERENCE function in SQL Server. The DIFFERENCE() function helps in data matching based on the sound of the data. First, you will be introduced to the DIFFERENCE() function and how it finds the difference between strings. Then, the syntax of the DIFFERENCE() function. After that, … Read more
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
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
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
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
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
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