Define column based on another column

Define column based on another column input value.

CREATE TABLE Sample
(
ID INT  IDENTITY(1,1)PRIMARY KEY,
TID AS(RIGHT('0000000000' + CONVERT(VARCHAR,ID),10)),
Name VARCHAR(50)
)

INSERT INTO Sample
(Name)
SELECT 'SAT1'

That’s It.
Enjoy Learning.