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 vote169 views1 answer
Delete a record from a table sqlite3
SQL
0 vote167 views1 answer
Oracle last connexion
SQL
0 vote170 views1 answer
Sql last time database was accessed
SQL
0 vote164 views1 answer
Docker open terminal mysql server
SQL
1 vote154 views1 answer
Mysql size int
SQL
0 vote151 views1 answer
Mysql bash execute sql file
SQL
2 votes143 views1 answer
Postgresql update sequence next value
SQL
0 vote159 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote152 views1 answer
Mysql query to add hours to column in table
SQL
9 votes149 views4 answers
Mysql show table fields
SQL