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

-1 vote186 views2 answers
Postgresql user permissions to database
SQL
1 vote219 views1 answer
Oracle user last connection date
SQL
0 vote201 views1 answer
Mssql dockere
SQL
0 vote193 views1 answer
Enable Rabbitmq management plugin
SQL
14 votes190 views3 answers
Alter foreign key
SQL
0 vote185 views1 answer
Wordpress database query change url
SQL
0 vote175 views1 answer
Duplicate foreign key constraint name
SQL
2 votes183 views1 answer
Mysql query unique column
SQL
3 votes190 views2 answers
Truncate all tables
SQL
0 vote188 views1 answer
Groupby error in mysql
SQL