Description of Getting the ID number of an inserted record :
Now the developers can retrieve the ID number of a just inserted record with the help of this online article. With the help of SQL server it is good to use a single stored procedure which executes both the INSERT and the IDENTITY operation using @@IDENTITY. For the stored procedure the author gives a sample source code. In the final part the author demonstrates the same task with the help of Access.