PATINDEX Function in SQL Server

PATINDEX Function in SQL Server

In this SQL Server tutorial, you will understand how to use the PATINDEX function in SQL Server. It is helpful in data manipulation and retrieval. First, you will understand the definition of the PATINDEX() function with syntax; then, with different examples, you will learn how to find the index of the specified pattern in the … Read more

SQL Server UNICODE Function

What is SQL Server UNICODE Function

In this SQL Server tutorial, I will show you how to handle the character sets using the SQL Server UNICODE function. suppose you are handling a database based on the global label containing different types of data in different languages. This function is very helpful in that case, allowing you to handle the international character … Read more

SQL DATEFROMPARTS Function

Creating Date using SQL DATEFROMPARTS Function

In this SQL Server tutorial, I will explain the SQL DATEFROMPARTS function, which is a date and time-based function that allows us to manipulate date and time values. Whether you are a developer or a student, this function is very helpful, as it constructs a new date from the specific parts of the date like … Read more

DATEADD Function in SQL Server

DATEADD Function in SQL Server

In this SQL Server tutorial, I will explain the DATEADD function in SQL Server, which allows us to manipulate the date part. This function is very useful in situations where you need to quickly compute the age of employees, schedule events, etc. First, you will understand its definition with syntax, and then, with examples, you … Read more

ISDATE Function in SQL Server

ISDATE Function in SQL Server Checking Valid Datetime Value

In this SQL Server tutorial, you will understand how to use the ISDATE function in SQL Server. First, I will explain the ISDATE function in SQL Server, its syntax, and how to use it. With an example, you will understand how it works or how it evaluates the given value. Then, you will use the … Read more

QUOTENAME function in SQL Server

QUOTENAME function in SQL Server with Variable

In this SQL Server tutorial, you will learn how to put the character around the string using the QUOTENAME function in SQL Server. You will understand how the QUOTENAME() function works and why you should use it. Then, with an example, you will understand how it wraps the string with characters. You will use the … Read more

TRANSLATE Function in SQL Server

TRANSLATE Function in SQL Server

In this SQL Server tutorial, you will learn the TRANSLATE function in SQL Server, which helps replace the substring with a new string. Then, you will understand the ‘What exactly is the TRANSLATE () function?’ with syntax; after that, you will do a simple example to understand the workings of the TRANSLATE() function. Using an … Read more

COUNT_BIG Function in SQL Server

COUNT_BIG Function in SQL Server Tables

In this SQL Server tutorial, you will learn about the COUNT_BIG function in SQL Server. First, you will understand the COUNT_BIG() function, then the difference between the COUNT() and COUNT_BIG() functions. After that, the syntax of the COUNT_BIG() function. Then, you will learn how to use the COUNT_BIG() function with duplicate and unique table column … Read more

GROUPING_ID Function in SQL Server

GROUPING_ID Function in SQL Server

In this SQL Server tutorial, you will learn about the GROUPING_ID function in SQL Server to identify the rows where the aggregation operation is applied. You will understand the GROUPING_ID() function with its syntax and know how it works through an example. GROUPING_ID Function in SQL Server The GROUPING_ID function in SQL Server is used … Read more

STUFF Function in SQL Server

Formatting Date Value using STUFF Function in SQL Server

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