HOW TO GENERATE UNIQUE ID(CHARACTER + NUMBER) FOR CUSTOMER IN SQL SERVER

HERE IN THIS SQL Tutorial WE WILL GENERATE UNIQUE ID(CHARACTER + NUMBER) FOR CUSTOMER IN SQL SERVER

Example:
Step 1 :- Create Database

Create Database Bank_db

Step 2:- Create Table

create table Customer{
ID int IDENTITY(1,1) NOT NULL,
PerFix varchar(50) NOT NULL,
CustomerNo AS(PerFix+RIGHT('0000000'+CAST(ID AS VARCHAR(7)),7)) PERSISTED,
CustomerName  varchar(50)
};

Step 3 :-

INSERT INTO Customer (PerFix,CustomerNo) Values('SBI','VIRAJ')
INSERT INTO Customer (PerFix,CustomerNo) Values('SBI','ANIL')
INSERT INTO Customer (PerFix,CustomerNo) Values('SBI','RUPESH')

Step 4 :-  Output

Select CustomerNo,CustomerName From Customer

Here Is The Video Related To Topic