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 vote176 views2 answers
Mysql unique two columns
SQL
29 votes223 views6 answers
Delete all rows from table mysql
SQL
0 vote178 views1 answer
Mysql search multiple tables
SQL
2 votes207 views5 answers
Tablespace ORACLE
SQL
0 vote187 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote186 views1 answer
Oracle webcenter content search enginer
SQL
0 vote198 views1 answer
MySql Modify Increment
SQL
0 vote197 views1 answer
Phpmyadmin mysql conflict
SQL
2 votes179 views2 answers
Exec procedure pl sql
SQL
2 votes193 views1 answer
Mysql application.properties spring boot
SQL