Find the Missing Identity Numbers in SQL Server

Question

How to find missing numbers in one table

Priyaranjan K S · Answer

Hi Vamsi  Please go through this link for better understanding : http://www.sqlservercurry.com/2009/06/find-missing-identity-numbers-in-sql.html Thanks Priyan If you found this useful Please Accept this as Answer

Sujeet Suman · Answer

Vamsi please once go through below link. This may help you: http://stackoverflow.com/questions/1389605/sql-find-missing-ids-in-a-table If this is helpful for you then please accept my Answer .