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 vote139 views1 answer
What is logical database schema
SQL
0 vote147 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
1 vote143 views1 answer
Apex ORA-20999
SQL
1 vote150 views1 answer
Operator does not exist: integer = text
SQL
0 vote154 views1 answer
Sql list dates between two dates
SQL
4 votes234 views4 answers
Update select mysql
SQL
6 votes159 views2 answers
Sql display max value
SQL
4 votes144 views1 answer
Sql delete where in select
SQL
0 vote150 views1 answer
Yesql
SQL
31 votes148 views3 answers
Sql count(*)
SQL