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

1 vote283 views1 answer
Round one decimal place mysql
SQL
0 vote263 views1 answer
Mysql query problems and solutions
SQL
8 votes275 views1 answer
Oracle current date plus 1 month
SQL
0 vote265 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote272 views1 answer
Sql server alter table column nullable
SQL
1 vote270 views1 answer
Find a column in all tables postgres
SQL
8 votes232 views2 answers
Alter column name in mssql
SQL
0 vote291 views1 answer
Mysql edit trigger
SQL
3 votes272 views4 answers
Psql list tables in schema
SQL
0 vote274 views1 answer
List all permissions on a table in postgres
SQL