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 vote237 views1 answer
Mysql default uuid
SQL
0 vote232 views1 answer
Sql database connectivity
SQL
0 vote235 views1 answer
Mysql count grouped rows
SQL
2 votes304 views5 answers
Tablespace ORACLE
SQL
1 vote254 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
1 vote252 views1 answer
Right outer vs left outer join
SQL
3 votes237 views1 answer
Select table column in sql
SQL
23 votes256 views4 answers
How to show all users in mysql
SQL
0 vote199 views1 answer
Create bakupd database sqlserver
SQL
17 votes238 views3 answers
Postgresql version command
SQL