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 vote110 views6 answers
Unique key in sql
SQL
1 vote117 views1 answer
Sql eliminare un record
SQL
0 vote111 views1 answer
Oracle list index on table
SQL
0 vote128 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote120 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote131 views1 answer
Check database restore status sql script
SQL
1 vote116 views1 answer
Duplicating a MySQL table with all the data Command
SQL
8 votes116 views2 answers
Update sql server from another table
SQL
0 vote116 views1 answer
Postgres list tables and row counts
SQL
2 votes251 views1 answer
Set auto increment from 1
SQL