Generate SQL Indentity Column in User Defined Formate

CREATE TABLE [dbo].[Tbl_BarCode](
     BarCode int NOT NULL PRIMARY KEY,
    CombinedId AS 'ABCD-' + CAST(BarCode as varchar(16)) ,

    [BarcOdeDescription] [nvarchar](50) NULL,
    [CreatedBy] [nvarchar](50) NULL,
    [CreatedDate] smalldatetime,
   

0 comments:

Post a Comment