In my search, a method for creating a unique series of series of numbers. I reviewed the identity column. I could not use it for my purpose, but this led to my current question;
How does the identifier technically work on the Sql server?
I am not looking for an answer on how to use it, I know that it increases the number per insert, leaving spaces when deleted. But I could not find documentation on how it generates it. Is this a table in sql server? Does it use row locking? Or some other castle? Is it a lock? How to prevent duplication of numbers?
source
share