My table values are follows.
When I insert a new item to the table, it should assign a No.3 as ID (ie.Miimum Number available).
Is there any way in the sql-server2005 to auto-assign the pk-field with minimum available number.
Now I am doing it programatically (in the button click event read all the ID from the table and computing this ID prgramatically and inserting new item with this ID.)
This may cause cuncurrency because there is gap for computation between fetching the value and inserting new item with this value