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

8 votes131 views4 answers
How to calculate the age from date of birth in python
SQL
34 votes140 views6 answers
Install mysql client ubuntu
SQL
0 vote82 views1 answer
Mariadb list tables
SQL
0 vote124 views1 answer
Oracle sql add column auto generated value
SQL
1 vote137 views1 answer
Sql in array query
SQL
0 vote121 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote108 views1 answer
Dump multiple tables mysql
SQL
11 votes127 views1 answer
Creating tables in sql with python
SQL
1 vote135 views1 answer
Mysql show long running queries
SQL
2 votes121 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL