Hi
You can get expected by modify the Table Schema by adding new Column for EmpCode like below
create table tblEmpCodeTest (ID bigint identity(1 ,1),
EmpCode as 'CG'+Replicate('0', 3 - LEN(ID))+ cast(ID as varchar) persisted not null primary key ,
FirstName varchar(10))
Note : MS SQL Server DB Query
Thanks
Siva Rm K