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

22 votes342 views4 answers
Mysql date format
SQL
20 votes354 views5 answers
Sql show tables
SQL
0 vote333 views1 answer
Mysql terminal list table
SQL
1 vote350 views1 answer
Python escape mysql
SQL
0 vote363 views1 answer
Psql generate id in existing database
SQL
1 vote350 views1 answer
Mysql workbench in ubuntu 14.04
SQL
7 votes334 views1 answer
Forge server hosting
SQL
1 vote357 views1 answer
Sql server: query to find out all the places where the table is used
SQL
5 votes360 views2 answers
Sql number columns
SQL
0 vote364 views1 answer
Oracle execute package dblink
SQL