Hi,
I reckon, the so called problem is
You have inserted 3 records initially like
ID Name Value
1 RK 100
2 Karthick 200
3 Prabakar 300
You have deleted
ID 2 and 3 from the table,
now you are inserting another set of records like
Mani 400
Kaajal 500
into the table, now it is inserted as
4 Mani 400
5 Kaajal 500
Final table content would be like this
ID Name Value
1 RK 100
4 Mani 400
5 Kaajal 500
If am right then this is not a problem in sql server,then you should refer this
link[
^]
Hope this could help you a bit.
Regards,
RK