Create Procedure SP_Recycle
AS
Declare @Maxid Int, @ SQL VARCHAR (8000)
IF EXISTS (Select * from T)
Begin
SELECT @ maxid = max (id) from T
CREATE TABLE #T (ID INT)
Set @ SQL = 'SELECT TOP' CAST (@maxid as varchar) 'Identity (int, 1, 1) ID
INTO #Tem from syscolumns a, syscolumns b, syscolumns c
Insert #t
SELECT * FROM #TEM
Drop Table #tem '
EXEC (@SQL)
Select ID from #t where not exists (select * from t where id = # T.ID)
DROP TABLE #T
End
Go
