And perhaps a SP to put them together when inserting?
On Nov 18, 1:39 am, Raghupathi Kamuni <[email protected]> wrote: > May be you have to maintain the Registration numbers in another table > say.... > > CREATE TABLE [dbo].[Registration]( > [Year] [int] NOT NULL, > [RegistrationNumber] [int] NOT NULL > ) > > Based on the year, you have to autoincrement RegistrationNumber. > > While inserting Student_Details generate the Student_ID from > RegistrationNumber
