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

8 votes205 views1 answer
Oracle search text in all packages
SQL
14 votes200 views4 answers
Import database through command line
SQL
1 vote196 views1 answer
Mysql pretty date format
SQL
0 vote202 views1 answer
Can sqldatareader be null
SQL
0 vote223 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote235 views1 answer
Alter fedora mysql 8.0 user
SQL
28 votes287 views6 answers
Foreign key
SQL
0 vote194 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote197 views1 answer
Oracle service name view
SQL
0 vote177 views1 answer
Oracle list chain steps
SQL