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 votes136 views6 answers
Create sql table
SQL
0 vote124 views1 answer
Mysql create table columns with spaces
SQL
10 votes124 views4 answers
Sql pagination
SQL
0 vote110 views1 answer
Mysql sleep connections
SQL
16 votes135 views3 answers
Update table from another table
SQL
7 votes133 views3 answers
Python and mysql connectivity
SQL
0 vote156 views1 answer
C# select Mysql
SQL
0 vote145 views1 answer
Play framework connection via windows sql server
SQL
1 vote129 views1 answer
Where not in array sql
SQL
3 votes167 views2 answers
Brew restart mysql
SQL