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

4 votes230 views1 answer
Sql select limit range
SQL
8 votes185 views3 answers
Alter table auto_increment
SQL
6 votes190 views2 answers
Mysql set primary key
SQL
1 vote187 views2 answers
Postgres copy table from one schema to another
SQL
2 votes206 views1 answer
Sql update \
SQL
1 vote196 views1 answer
Raw query must include primary key
SQL
0 vote195 views1 answer
Mysql update from n to 100
SQL
0 vote186 views1 answer
Sql server current time without date
SQL
0 vote202 views1 answer
Mysql case when null
SQL
0 vote234 views1 answer
Update mysql from paypal shopping cart and ipn
SQL