SQL Server Education (by the geeks, for the geeks)
When we define a table with Identity column, SQL Server might cache the identity values to improve performance. Due to server restart or database failure some assigned values may be lost. …
SQL SERVER 2017 – IDENTITY_CACHE Read MoreThis is the third part of this blog series. You can read the 2nd part here Here. In this blog post we’ll learn how to retrieve last generated identity value. There are scenarios where …
Identity Property Part – 3 Read MoreThe SQL Server error code 544 – Cannot insert explicit value for identity column, occurs when one tries to insert an explicit value for an identity column and identity_insert is off …
SQL Server error code 544 – Cannot insert explicit value for identity column Read MoreThese are the most common functions to work with identity values in SQL Server. This blog looks at IDENT_CURRENT vs. SCOPE_IDENTITY vs. @@IDENTITY vs. IDENTITY comparison. Let’s look at the definition …
IDENT_CURRENT vs SCOPE_IDENTITY vs @@IDENTITY vs. IDENTITY in SQL Server Read MoreHi Folks, What is IDENTITY_INSERT? I am sure that all of you would be aware about the role of Identity column in a table, i.e., it is column which keeps on …
What is IDENTITY_INSERT? Read More