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

11 votes237 views4 answers
Round in sql
SQL
0 vote185 views1 answer
Connection error in mysql workbench
SQL
0 vote243 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote295 views1 answer
Redshift running queries
SQL
0 vote257 views1 answer
Sql cmd no truncate
SQL
3 votes256 views3 answers
Postgresql random number
SQL
0 vote234 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote317 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote230 views1 answer
SQL isnumeric DB2
SQL
0 vote232 views1 answer
Use where instead of join
SQL