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 vote370 views1 answer
Sql decimal to 2 places
SQL
0 vote332 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote367 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
1 vote290 views1 answer
Postgres kill pid
SQL
0 vote317 views1 answer
Laravel eloquent get generated sql
SQL
1 vote324 views1 answer
Oracle duration between timestamps
SQL
0 vote322 views1 answer
Sql server cannot create database diagram
SQL
0 vote316 views1 answer
How to avoid duplicate records in sqlite
SQL
25 votes356 views6 answers
Import database mysql command line
SQL
0 vote335 views1 answer
Test the postgresql db connection
SQL