my question is based on project

Question

in my project in registration table rid column need to be autoincremented with some constant text  with this incremented no. These constant text and the autoincremented no i have to store in database. plz need help e.g rid=REG-01 in first column,rid=REG-01 in second column

Cynthia Sathuragiri · Accepted Answer

CREATE TABLE [dbo].[REGISTRATION]( [ID] [int] IDENTITY(1,1) NOT NULL, [RID] AS ('REG'+ RIGHT('0' + CAST(Id AS VARCHAR(7)), 7)) PERSISTED, [Name] VARCHAR(50), CONSTRAINT [PK_AutoInc] PRIMARY KEY ([ID] ASC) ) --Create Unique Index on the [RID] column. CREATE UNIQUE INDEX [UK_AutoInc] ON [dbo].[REGISTRATION] ( [RID] ASC )

asha pawar · Answer

thank uuuu so muchhh