How to finding gaps in identity values?

[VNDN]

will someone help me for indentifying gaps in identify values when data is removed in SQL 2000. Thanks in advance.DN

 

[zhavic]

This gives you IDENTITY values, after which are gaps:

SELECT T1.Identity_column
	FROM Your_table T1
		LEFT JOIN Your_table T2 ON T2.Identity_column = T1.Identity_column + 1
	WHERE T2.Identity_column IS NULL
	ORDER BY T1.Identity_column

Zhavic


---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.