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 vote194 views1 answer
Drop view sql
SQL
150 votes334 views10 answers
Grepper
SQL
0 vote149 views1 answer
Soql user profile
SQL
7 votes121 views1 answer
Safe mode mysql
SQL
0 vote157 views2 answers
Transaction php
SQL
1 vote185 views1 answer
Insert column after column mysql
SQL
0 vote143 views1 answer
Mysql locate
SQL
1 vote134 views2 answers
Mysql current user
SQL
0 vote140 views1 answer
Mysql two joins
SQL
0 vote92 views1 answer
Update row in sqlite python
SQL