In this SQL Server tutorial, I will show you how to create a view in SQL Server Management Studio. You may be familiar with a query or the command that allows you to create a view but want to extend your knowledge to create a view using the SSMS, so I have explained step by … Read more
In this SQL Server tutorial, I will explain the SQL Server change column to NOT NULL. I created an e-commerce website that was running smoothly, but one day, I realized that the column stock could store null values. I needed to fix this issue because these columns must not contain null values. So, I used … Read more
In this SQL Server tutorial, you will learn how to rename column name in SQL Server. Sometimes, a situation arises due to changes in the business logic where you will have to change the column’s name in the table. Considering that situation, I have explained two methods in this tutorial for renaming a column in … Read more
In this SQL Server tutorial, I will show you how to create an identity column in SQL Server. As a beginner, you must know how to insert unique records in a table and avoid duplicating records from inserting. So, here, I will explain a clause called IDENTITY that helps insert unique records into a table … Read more
In this SQL Server tutorial, You will learn about SQL Server split string into rows. As a database developer or data engineer, sometimes, you need to split a string into rows while processing data. You will understand two methods to split a string into rows; in the first method, you will use the STRING_SPLIT() function, … Read more
I will explain how to use IF-ELSE in SQL server stored procedure in this SQL Server tutorial. First, I will introduce the syntax of the IF-ELSE in SQL Server. Then, with an example, you will learn how to use the if-else in the stored procedure. You will create a stored procedure containing the if-else statement … Read more
As a database developer, you must know how to delete stored procedures in SQL Server when they are no longer needed. In this SQL Server tutorial, I will explain two methods for removing stored procedures from the database. In the first method, you will use the SSMS to delete the stored procedures; in the second, … Read more
In this SQL Server tutorial, you will understand the FOR loop in SQL Server stored procedure and learn how to use it. As a database developer, if you are familiar with SQL Server, then you already know that SQL Server doesn’t have a FOR loop. So, I will explain how you can simulate the FOR … Read more
In this SQL Server tutorial, I will show you how to create temp table in SQL Server stored procedure. First, I will explain a temp table and its use in stored procedures. Then, with the example, you will understand how to use the CREATE TABLE command in the stored procedure to create a temp table. … Read more
In this SQL Server tutorial, you will understand how to view stored procedures in SQL Server. As a database developer, you must know how to view a stored procedure, which is helpful in many ways, such as debugging, optimizing, and understanding database schema. So, here I will explain how to view stored procedures using SSMS … Read more