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 vote154 views1 answer
Mysql select row with max value group by
SQL
0 vote230 views2 answers
Return the number of records in a single table mysql
SQL
1 vote178 views1 answer
Increase existing date in sql oracle
SQL
0 vote177 views1 answer
Nuget sqllite-net-pcl
SQL
11 votes152 views5 answers
How to install sqlite3 python
SQL
1 vote153 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote160 views1 answer
Oracle sql copy table without data
SQL
0 vote160 views1 answer
Proc sql not in working
SQL
0 vote155 views1 answer
Display first three characters sql
SQL
0 vote164 views1 answer
Trigger stock phpmyadmin output message
SQL