Temp tables in SQL Server can be local or global. The name of the local temporary table starts with a # symbol, whereas the name of the Global temp table starts with a ## symbol. Below are two simple approaches to creating the temp table. Approach 1: Using the standard Create statement You can use … Read more
We can use the identity column to generate an autogenerated and identity value in SQL Server. It has 2 values: seed and increment. Now, the new values will be autogenerated based on these values. The syntax is like below. Now, Let’s understand this concept with an example of when the reset identity column is required … Read more
There are multiple ways to check if a column is identity in SQL Server. We will discuss each approach individually. How to check if column is identity in SQL Server Approach-1: Using SQL Server Management Studio UI This is the most basic approach that you can utilize. For example, I have an Orders table with … Read more
I recently participated in a webinar, and one guy asked me about the possible approaches to disabling the identity column in SQL Server. Let me summarize the information for you. To turn off the identity column in SQL, you must set the IDENTITY_INSERT property to OFF. Let’s look at the complete steps with an example … Read more
By default, the SQL server won’t allow you to explicitly insert a value for an identity column. But I was surprised to see a requirement that I got from my client. There is no need to insert an explicit value for the identity column as it is auto-generated and auto-incremented. You just need to provide … Read more
I was working with my team on a requirement from one of my clients. We were required to add an identity column to an existing critical table in our SQL database. As part of the article, I will explain our approaches to handling this, as it is not supported directly. Note that you can’t directly … Read more
The identity column is crucial for maintaining data integrity and ensuring that each row of your table contains an autogenerated and unique value. It is also crucial in case you are setting primary keys. Note that you can set only one identity column in a table. Once you set the identity property, it is impossible … Read more
Due to certain maintenance activities on my client’s end, I recently encountered a requirement to copy one critical table to another in our SQL Server database. As we all know, this is a common task in database management, and several approaches exist depending on the specific needs and constraints. In this article, I will discuss … Read more
Truncating a table in SQL Server is a rapid and efficient way to remove all the data from a table without deleting the table structure. So, first of all, you should be very careful before trying to execute the TRUNCATE command. Here’s a real-time approach to achieve this. To truncate a table in SQL Server … Read more