Microsoft SQL Server Tutorials
It will support the integrity of all the given data, keeping the SQL Server database free from duplicates. The concept of CTE utilizing ROW_NUMBER() helps manage the order number for the number of records, so it is perfect for finding and effectively deleting duplicate records in SQL Server. In this SQL Server tutorial, you will … Read more
ROW_NUMBER() is a common function in SQL Server. It generates a number in sequential order for each row, beginning with 1. To make sure that the numbers are assigned in the correct order, we must always use the ORDER BY procedure. Data types of BIG INT are used for the values that this function returns. … Read more
Do you know the naming convention for the stored procedure? If not, no worries. Follow this simple and easy tutorial to see the rules for naming conventions in stored procedures. Stored Procedures in SQL Server A stored procedure consists of one or more statements that perform specific tasks. They usually include statements that are used … Read more
Are you aware of the SQL Server Set identity_insert function? If not, follow this tutorial to learn more about this. What is identity_insert? The IDENTITY_INSERT tells an SQL Server’s table whether to allow the identity column’s value to be inserted. Use identity_insert in Table Let’s look into the simple creation of a table using the … Read more
Identity columns are essential in maintaining data integrity and helping you develop the ability to perform operations with data efficiently under database management. Therefore, when you add identity to existing column in SQL Server, it will allow smooth data operation and high system performance. This SQL Server tutorial explains the concept of identity in a … Read more
Foreign Keys are a key component of SQL Server. They help link two tables while maintaining the relationship, so data can be maintained without mixing everywhere. This is quite important, and the general operation of a foreign key in SQL Server is briefly described in the SQL Server tutorial. This is followed by explaining how … Read more
In this SQL Server tutorial, I will show you how to reset identity column in SQL Server. You will learn about the identity column and its syntax with why to reset the identity column. But why you need to reset, there are multiple reason, I have explained some of the reason in this tutorial. For … Read more
In this SQL Server tutorial, I will show you how to insert identity column in SQL Server. Inserting the unique ID for each record in the table is not a good approach, so SQL Server provides an attribute called Identity column, which tells SQL Server to generate a unique value for each record automatically. In … Read more
In this SQL Server tutorial, I will explain the while loop in the SQL Server stored procedure. Whenever I am required to execute complex logic for many records in a table, I use the while loop to avoid writing this logic again and again; I encapsulate this logic into a stored procedure, so whenever I … Read more
In this SQL Server tutorial, you will learn about SQL Server find string in a string. While analysing the data, I needed to find the specific existence of the strings within the data containing strings. Actually, I needed to find the specific pattern of strings, so for that, I used the CHARINDEX() function. Apart from … Read more