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 vote221 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote231 views2 answers
Mysql error 1215
SQL
3 votes245 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote243 views1 answer
Show mysql account privilleges
SQL
36 votes236 views6 answers
Rename table sql
SQL
0 vote230 views1 answer
How to to get current date in sql
SQL
0 vote252 views2 answers
Generate sql trigger through ef migration
SQL
0 vote219 views2 answers
Mysql regexp match word
SQL
-1 vote239 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote232 views1 answer
User, group, or role 'open' already exists in the current database.
SQL