When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table:
It has Ids -1, 1, 2, 3, 4, 5 … but no 6 or 7. (Or 0.) If someone asks you to find all the Ids that got deleted or skipped, how do we do it?
Using GENERATE_SERIES with SQL Server 2022 & Newer
The new GENERATE_SERIES does what it says on the tin: generates a series of numbers. We can join from that series, to the Users table, and