Tag Info

New answers tagged

0

Use an IDENTITY column for the incrementing ID value, then prefix it with 11- as a computed column. CREATE TABLE [Table2] ( ID int IDENTITY(1,1), ID_pretty AS ('11-' + CAST(ID AS nvarchar)) CONSTRAINT pk_ID PRIMARY KEY (ID)) GO



Top 50 recent answers are included