Microsoft SQL Server Tutorials
In this SQL Server tutorial, I will show you how to drop a table if it exists in SQL Server. As a database developer, whenever the business logic changes, sometimes table objects become unnecessary, so removing these unnecessary objects is very important. In this tutorial, I have explained how to drop one of the objects, … Read more
In this SQL Server tutorial, I will explain the SQL Server drop column with constraint. Sometimes, you need to drop a column when it is no longer needed, but if any constraint depends on the column you want to drop, you may not be able to drop that column, and it will show an error … Read more
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