KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
If you add a new record, then delete the record, then add it again over and over, in time, sooner or later, when you add a new record the integer primary key id, it will eventually exceed 2 billion. Now what happens? SQL Server will start the primary key id from 1 again? or -1? What happens if it cycles 4 billion times; how does SQL Server know not to replace the previous data?
Tags (comma-separated)
Save Edits
Cancel