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 vote176 views1 answer
Mysql remove last character
SQL
0 vote173 views1 answer
H2 auto increment and unique
SQL
0 vote181 views1 answer
ACCEPT nome PROMPT on oracle
SQL
3 votes172 views1 answer
Sql case update
SQL
1 vote151 views1 answer
Sql myisam vs innodb
SQL
0 vote188 views1 answer
Sql to excel pgadmin
SQL
1 vote191 views1 answer
Get current date in pyspark sql
SQL
3 votes196 views3 answers
1396(hy00) mysql error
SQL
11 votes170 views3 answers
Sqlite3 create table from another table
SQL
0 vote182 views1 answer
Ver usuarios mysql
SQL