Microsoft SQL Server Tutorials
In this SQL Server tutorial, you will learn about the VAR Function in SQL Server, where you will learn about the variance and how to compute it using the VAR() function. Also, you will learn how to use this function when your dataset has duplicate values; as you know, duplicate values or unwanted data in your … Read more
In this SQL Server tutorial, you will learn about the STDEV Function in SQL Server, where you will learn about the standard deviation and how to compute it using the STDEV() function. If you are a data analyst or data science enthusiast, this function is very helpful, as it lets you quickly retrieve the given … Read more
In this SQL Server tutorial, you will learn about the ORDER BY clause in SQL Server, where you will sort the data in a specific order. You will understand the general syntax of the ORDER BY clause that you can use anywhere in your SQL Server query. Then, you will order the rows in ascending … Read more
In this SQL Server tutorial, I will teach about the STRING_ESCAPE function in SQL Server, where you will understand how to escape the special characters in the string. I will explain the syntax you can use in your query to escape the special or control characters and what kind of parameter this function requires. Then, … Read more
In this SQL Server tutorial, you will learn how to use the DAY function in SQL Server, where you will work on the day part of the given datetime value. You will learn how to use the DAY() function with only literal date and on the table columns; then, you will learn where to use … Read more
In this SQL Server tutorial, you will learn how to use the GROUP BY clause in SQL Server to group the rows of data. You will understand the scenarios where you can apply the GROUP BY clause in SQL Server. Then the syntax of the GROUP BY clause. After that, with practical examples, you will … Read more
This SQL Server tutorial will teach you about the SQL Server DATE_BUCKET function with syntax and examples. You will understand how to analyse time-based data using the DATE_BUCKET() function, where you will apply the DATE_BUCKET() function on the table and where it can be beneficial. SQL Server DATE_BUCKET Function SQL Server DATE_BUCKET function creates the … Read more
In this SQL Server tutorial, I will teach you about the DATALENGTH function in SQL Server with different examples. While working the database, such as retrieving information or performing any operations on the data table, for example, you may need to check the size of the information stored in the table’s column or increase the … Read more
In this SQL Server tutorial, you will learn about SQL Server escape single quote in string with examples. Sometimes, when you want to insert or find the string containing a single quote through the query, and if you don’t know how to handle the single quote in SQL Server, you usually get the error. Here, … Read more
This SQL Server tutorial will teach you about SQL Server count characters in string. You will learn about the two methods, LEN() and DATELENGTH(), to count the number of characters in the given string. SQL Server Count Characters in String Counting characters in a string means checking the length of the given string. Suppose you … Read more