SQL Server - How to get particular row ID which has been deleted in table

Asked By Bhanu Pratap Singh on 18-Jul-14 08:47 AM
Hello !
Mr. Robbe Morris,

I want to insert row into table over that row which has been deleted from table.
Because Row ID is auto increament. 
for exam:--
ID Auto increment 
1
2
3
4
5
suppose :-  ID No 2 has been deleted. Therefore ID 2 is missing in the table.
I want to insert a record in place of ID 2.
So how to get ID 2 row and then I could be able to insert value in columns on ID 2

Thanks
Robbe Morris replied to Bhanu Pratap Singh on 18-Jul-14 09:48 AM
Even with Set identify_insert tableName Off, you cannot insert a specific value into that column in SQL Server.  If you have any sort of logic that requires these keys to backfill each other on deletion, you've got a flaw in your architecture.