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

2 votes192 views3 answers
Sql delete duplicate
SQL
0 vote180 views1 answer
Sql query to delete row by id
SQL
0 vote219 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
11 votes183 views6 answers
Mysql else if
SQL
1 vote187 views3 answers
Reset sql primary key
SQL
0 vote173 views1 answer
Cast for print sql
SQL
3 votes186 views1 answer
Sql print all names that start with a given letter
SQL
0 vote192 views1 answer
Mysql local password denied
SQL
0 vote193 views1 answer
How to close external sql connection in laravel
SQL
8 votes196 views2 answers
Grant all privileges database postgres to user
SQL