Microsoft SQL Server Tutorials
It is essential to test stored procedures in SQL Server to know stored procedures’ functionality, performance, and accuracy while handling data processing tasks. In this SQL Server tutorial, I will explain different approaches for testing stored procedures and why it is important to test the stored procedure. Also, you will understand how to perform unit … Read more
As a database developer, you sometimes need to rename stored procedure in SQL Server as business logic changes. So, in this SQL Server tutorial, I will show you the steps to rename the existing stored procedure in your database, which is an essential skill every SQL Server developer must have. You will understand the syntax … Read more
Knowing about functions is very important cause it reduces the repetitive task. I will show you how to CREATE FUNCTION in SQL Server in this SQL Server tutorial. You will understand what function is, why to use the function, and how it reduces the repetitive task by encapsulating complex logic. Then, with syntax, you will … Read more
In this SQL Server tutorial, I will explain how to use the RANK function in SQL Server, which ranks the rows in the result set. First, I will describe the RANK() function with syntax, and then, with an example, you will understand how to use this function to assign rank to rows. After that, you … Read more
As a database beginner, you must be able to organize, manage and secure database objects; in this tutorial, I will show how to CREATE SCHEMA in SQL Server. You can put the schema-related database objects in by creating a schema. First, I will explain what schema is and why it is created. Then, with syntax, … Read more
As a database developer, you must know how to retrieve the information from the database based on the logical condition; here, I will explain SQL Server IIF logical function. This function allows us to evaluate the condition as true and false and, based on that, returns the specified value. I will start by explaining what … Read more
In this SQL Server tutorial, you will learn how to ALTER TABLE in SQL Server. You will understand the ALTER TABLE statement and why you should use it. Then, you will learn how to add a new column to an existing table, modify the column’s datatype, and drop the existing column of the table. Additionally, … Read more
Handling null values is a very important skill. As a database developer, you should know how to deal with null values in your table. This tutorial will explain how to use the SQL Server COALESCE function. A COALESCE() function is the one way to deal with null values; here, you will understand what the COALESCE() … Read more
In this SQL Server tutorial, I will explain how to apply conditions logic in your query using the CASE statement in SQL Server. As a database developer, you must understand how to use CASE statements to simplify the condition logic in your query. Also, how to categorize the data as requirements arise more simply. First, … Read more
In this SQL Server tutorial, I will show you how to use the CHOOSE function in SQL Server; this function helps in complex decision-making logic and simplifies the data retrieval process. As a database developer, you must know how to use this logical function, which resembles the workings of a CASE statement. But it is … Read more