How to Rename Column name in SQL Server

Choosing Rename Option to Rename Column name in SQL Server using SSMS

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

How to Create an Identity Column in SQL Server

Create an Identity Column in SQL Server

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

SQL Server Split String into Rows

SQL Server Split String into Rows using STRING_SPLIT()

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

How to use IF-ELSE in SQL Server Stored Procedure

Creating IF-ELSE in SQL Server Stored Procedure

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

How to Delete Stored Procedures in SQL Server

Selecting Delete Option to Delete Stored Procedures in the SQL Server using SSMS

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

For Loop in SQL Server Stored Procedure

FOR loop in SQL Server Stored Procedure

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

Create Temp Table in SQL Server Stored Procedure

Create Temp Table in SQL Server Stored Procedure

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

How to View Stored Procedures in SQL Server

SQL Server Management Studio

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

How to Alter Stored Procedure in SQL Server

Checking the Stored Procedure with Parameter Value

In this SQL Server tutorial, I will teach you how to alter stored procedure in SQL Server. As a Database developer, administrator, etc., you should know how to modify the existing stored procedure. I will start by explaining why to change the existing stored procedure, then the syntax you can use to modify the stored … Read more

Create SQL Server Stored Procedure Default Parameter

SQL Server Stored Procedure Default Parameter Value

In this SQL Server tutorial, I will explain how to create an SQL Server stored procedure default parameter. Especially you will learn how to create a stored procedure with default parameters and values. I will explain the proper syntax for creating SQL Server stored procedures with default parameters. SQL Server Stored Procedure Default Parameter SQL … Read more