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 vote291 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote309 views1 answer
Kill slow queries mysql
SQL
0 vote285 views1 answer
Concat column value of same user in mysql
SQL
1 vote301 views1 answer
Backup mysql data only
SQL
10 votes356 views4 answers
Join multiple tables in sql
SQL
0 vote300 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote280 views1 answer
How to check if there is no database schema
SQL
0 vote337 views1 answer
CONVERT time string into 12 hours in sql
SQL
1 vote278 views1 answer
Mysql show current queries
SQL
0 vote277 views1 answer
Version and edition of SQL Server Database Engine
SQL