Primary key with prefix 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 vote287 views1 answer
Mysql set column equal to another automatic
SQL
26 votes281 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote298 views1 answer
How to reset the database value in SQL server
SQL
3 votes275 views3 answers
Into in sql
SQL
0 vote291 views1 answer
If column value is null then in mysql
SQL
0 vote246 views1 answer
CREATE MULTIPLE FK
SQL
2 votes311 views1 answer
Sqlplus clear screen
SQL
3 votes292 views1 answer
Async await mysql nodejs
SQL
-1 vote292 views1 answer
Partial search in sql
SQL
0 vote298 views1 answer
Sql drop procedure if exists
SQL