Please Give me the solution,Today I had a requirement that I have to get missing number form table and start new ID form that missing value...Ex. I have a customer table.ID Name1 Vijay2 Rajesh3 Nitin5 Manish6 Bipin8 JalpeshHere, 4 and 7 number are missing, some one have deleted that record. and now suppose user click on add new button he want to generate that missing number.Here a I have create a small cursor to get that value:DECLARE @lastID int,@crrID int SET @crrID=1;...