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 vote305 views2 answers
How to install psql in ubuntu
SQL
0 vote283 views1 answer
Select top values sql
SQL
0 vote273 views1 answer
Enable full text search mysql
SQL
0 vote287 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote275 views1 answer
Alter add syntax
SQL
0 vote277 views1 answer
Oracle exchange subpartition
SQL
2 votes300 views1 answer
Rails execute sql
SQL
0 vote283 views1 answer
Enable sql server full text indexing
SQL
0 vote338 views1 answer
How to subquey to do not load in live database in
SQL
0 vote284 views1 answer
Search mysql database for column
SQL