Column with prefix in 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 vote123 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote95 views1 answer
Postgres create database if not exists
SQL
0 vote81 views1 answer
How to get last client id sql
SQL
0 vote122 views1 answer
Sql composite key
SQL
0 vote88 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote186 views1 answer
Import sql dump into postgresql database
SQL
0 vote137 views1 answer
Update sqlite
SQL
0 vote129 views1 answer
Sql shell psql cannot enter password
SQL
2 votes170 views1 answer
Remove foreign key constraints in postgres
SQL
2 votes136 views2 answers
Mysql alter column default
SQL