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 vote201 views1 answer
Add timestamp column to existing table t-sql
SQL
1 vote200 views1 answer
Oracle grant on all tables in schema
SQL
0 vote204 views1 answer
Mysql change innodb to myisam
SQL
1 vote224 views1 answer
Sql and
SQL
11 votes209 views1 answer
Sql insert multiple rows from select
SQL
7 votes203 views2 answers
Create mysql user
SQL
0 vote222 views1 answer
Sqlcmd no headers
SQL
2 votes261 views1 answer
Mysql now format
SQL
0 vote194 views1 answer
Formatting code with SQL Developer
SQL
5 votes219 views1 answer
AND OR NOT operators sql
SQL