automatically updated id.
create table emp(_id int primary key identity(1,1))
i have 10 records,
i delete first record using id
delete from emp where _id=1
but i want to automatically updated if i delete record id 1
please give the solution for this,