Column with prefix in sql

create table  #test
(
Id int identity(1,1),
Pid as 'PRE-'+REPLACE(STR(id, 7), SPACE(1), '0')
)
 
INSERT INTO #test DEFAULT VALUES
INSERT INTO #test DEFAULT VALUES
select *From #test

Similar codes

0 vote109 views1 answer
Mysql extract day from date leading zero
SQL
0 vote153 views1 answer
Postgres rename database
SQL
0 vote97 views1 answer
Oracle sql date summer time
SQL
4 votes49 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote93 views1 answer
Change role postgres
SQL
0 vote105 views1 answer
Sql server convert to guid
SQL
0 vote94 views1 answer
Odd record sql query
SQL
-1 vote118 views1 answer
Create view in mysql workbench
SQL
0 vote118 views1 answer
SQL query to verify the size of the table
SQL
0 vote97 views1 answer
Create column that already exists mysql
SQL