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 vote342 views1 answer
Import all databases mysql
SQL
2 votes348 views1 answer
Apex execute batch job
SQL
6 votes335 views1 answer
Phpmyadmin reset root password
SQL
40 votes469 views4 answers
PostgreSQL add column
SQL
0 vote350 views1 answer
Grouping by email domain mysql
SQL
5 votes399 views4 answers
Traduction
SQL
-1 vote373 views3 answers
Compute age mysql
SQL
11 votes342 views2 answers
Sql between date range
SQL
0 vote348 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote346 views1 answer
Low level operator in dbms
SQL