Primary key with prefix 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 vote138 views1 answer
EnvironmentError: mysql_config not found
SQL
2 votes173 views1 answer
Oracle block
SQL
14 votes132 views2 answers
Oracle add attribute to table
SQL
0 vote140 views2 answers
What is rownum in oracle
SQL
11 votes116 views1 answer
Oracle insert into where
SQL
0 vote114 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote155 views2 answers
Postgres isnull
SQL
0 vote114 views1 answer
Sql beginning of previous month
SQL
0 vote121 views1 answer
Mysql Error Code: 1005
SQL
0 vote138 views1 answer
Mysql default tls v1.3 ciphersuites
SQL