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 vote160 views1 answer
Set engine to innodb
SQL
0 vote152 views1 answer
Allow external access to mysql
SQL
11 votes170 views1 answer
Oracle view source
SQL
6 votes241 views1 answer
Sql insert values into table
SQL
0 vote149 views1 answer
Mysql shell ERROR: Not connected.
SQL
5 votes157 views2 answers
Get number of columns sql
SQL
-1 vote152 views8 answers
Create Trigger in phpMyAdmin
SQL
5 votes170 views1 answer
Oracle create table comment
SQL
2 votes159 views1 answer
Add new column not null sql server
SQL
0 vote154 views1 answer
Where name ends in SQL
SQL