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 vote154 views1 answer
Generate sequence number in sql server
SQL
0 vote168 views1 answer
Sub blocks in sql
SQL
0 vote181 views2 answers
Raise notice in postgresql function
SQL
1 vote185 views1 answer
Mysql curdate between two dates
SQL
0 vote178 views1 answer
Get primary key of table
SQL
0 vote179 views1 answer
Change magento database url usimg musql
SQL
24 votes183 views6 answers
Rename a column in sql server
SQL
4 votes161 views2 answers
Mysql how to change default charset
SQL
5 votes163 views1 answer
How to check port number for postgresql
SQL
7 votes128 views1 answer
Alter table add key sql
SQL