Bijay Kumar Sahoo
In this SQL Server tutorial, I will explain the SUM function in SQL Server to add all the values of the given set of values. You will be introduced to the syntax of the SUM() function and its definition. Then, you will understand with a simple example how to use the SUM() function with table … Read more
In this SQL Server tutorial, you will learn how to use the REPLICATE function in SQL Server. You will learn where to use the REPLICATE() function with syntax and its definition. Also, you will use the REPLICATE() function with literal string or table columns and present the data visually using this function. REPLICATE Function of … Read more
In this SQL Server tutorial, you will learn how to use the SYSDATETIMEOFFSET function in SQL Server. You will learn how to use the SYSDATETIMEOFFSET() function with different time zones and also use it with table columns, especially using it as the default value for recording the exact timing of the data insertion. SYSDATETIMEOFFSET Function … Read more
In this SQL Server tutorial, you will learn about the GETDATE function in SQL Server that helps find the current date and time of the system. You will learn about the syntax of GETDATE() with an example and then how to use the GETDATE() function with a table column, where you will create a table … Read more
In this SQL Server tutorial, you will learn how to use the COUNT function in SQL Server to count the number of rows in a table. The COUNT() is a basic function for data analysis or another purpose, depending on the requirement. Here, you will understand the COUNT() function variants with syntax. Also, you will … Read more
If the database developer wants to get the exact time of a system on which the SQL server is currently running, they can use the CURRENT_TIMESTAMP Function provided by SQL Server. The CURRENT_TIMESTAMP() function returns the computer’s current time stamp in ‘YYYY-MM-DD hh:mm: ss.mmm’ format. This function is useful when we want to record additions or deletions … Read more
In this SQL Server tutorial, you learn about the LOWER function in SQL Server. Where you will be introduced to the syntax of the LOWER() function. Then you will learn how to use the LOWER() function with uppercase, mixed-case string, and string containing the special characters. In the end, you will learn how to use … Read more
In this SQL tutorial, you will learn about the UPPER Function in SQL Server, where you will learn how to transform the string to uppercase. Additionally, you will learn how to convert literal strings, mixed case strings, and other characters to uppercase using the UPPER() function. Finally, you will use the UPPER() function with table … Read more
In this SQL Server tutorial, you will learn how to use the REPLACE function in SQL Server. Where you will understand the workings of the REPLACE() function, and how to use it with a literal string, collation, and table columns. REPLACE Function in SQL Server The REPLACE() function in SQL Server replaces the substring of … Read more
In this SQL Server tutorial, I will show you how to use the SQL Server STR function, where you will understand how to convert the number to a string. You will learn about how the STR() function can be useful in various situations. Then syntax of the STR() function, as well as how to check … Read more