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 vote347 views1 answer
Denormalise SQL command
SQL
0 vote425 views1 answer
Sql cursor example multiple columns
SQL
1 vote342 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote437 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote338 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote362 views1 answer
Limiting query result using where in sql
SQL
5 votes362 views1 answer
Sqlite alter table add column
SQL
-1 vote435 views5 answers
Left join sql
SQL
0 vote309 views1 answer
Mysql offset from bottom
SQL
0 vote387 views1 answer
Postgresql extract hour and minutes from timestamp
SQL