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 vote288 views1 answer
Pl sql search in all packages
SQL
1 vote297 views1 answer
Find difference in dates sql
SQL
12 votes282 views2 answers
Delete all data in neo4j
SQL
4 votes277 views1 answer
Postgresql show current database
SQL
0 vote277 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote337 views1 answer
Create table using the clause with as
SQL
0 vote302 views1 answer
Drop domain postgresql
SQL
9 votes284 views3 answers
Where in sql
SQL
0 vote267 views1 answer
Sql requete number pair
SQL
0 vote282 views1 answer
Json_remove mysql
SQL