I am going to insert one record into the database (ex: table name : Student) by using a web application, here when am going to insert i will generate one RefNumber basing on the count of records +1 in that table and this RefNumber also inserted into the Student table. Fine, Here my problem is when two users accessing the same table going to insert a record into the Student table that RefNumber is missing to generate. So the problem is Same RefNumber is allocated to the two Students. Please let me know, how to handle two users accesing same table at same time.
I hope you all understand my problem. If anybody have an idea about this kind of issue let me know, it may helpful to me.
Thanks and Regards,
Maria Vinod Bheemisetty