SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[my_table](
    [V01_V] [real] NULL,
    [V02_V] [real] NULL,
    [V03_V] [real] NULL,
    [V04_V] [real] NULL,
    [V05_V] [real] NULL,
    [Date_Inserted] [datetime] NOT NULL,
    [Unique_ID] [int] IDENTITY(1,1) NOT NULL,
    CONSTRAINT [PK_row_id] PRIMARY KEY CLUSTERED
(
    [Unique_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO [dbo].[my_table] values (1,1,1,1,1, CURRENT_TIMESTAMP  ),(2,2,2,2,2, CURRENT_TIMESTAMP  )
2 rows affected

ALTER TABLE dbo.my_table ADD new_id AS ('04cust_' + CONVERT(varchar,Unique_ID));
SELECT * FROM [dbo].[my_table] 


V01_V
V02_V
V03_V
V04_V
V05_V
Date_Inserted
Unique_ID
new_id


1
1
1
1
1
2023-03-20 18:31:51.917
1
04cust_1

2
2
2
2
2
2023-03-20 18:31:51.917
2
04cust_2

V01_V	V02_V	V03_V	V04_V	V05_V	Date_Inserted	Unique_ID	new_id
1	1	1	1	1	2023-03-20 18:31:51.917	1	04cust_1
2	2	2	2	2	2023-03-20 18:31:51.917	2	04cust_2