identity number

[m_nathani]

hi,

 

How can finde missing number in identity column and insert particular missing number programmaticaly in SQL Server 2000.

[Derek Stone]

I can't think of a single reason as to why one would need to do that. Nevertheless...

SELECT id FROM table

Then loop through the returned records to find the "missing" rows. For each missing row execute the following T-SQL:

SET IDENTITY_INSERT dbo.tablename ON
GO
INSERT (id) VALUES (<identity>) INTO dbo.tablename
GO

... replacing "<identity>" with the one just found.