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

1 vote365 views3 answers
Sql server get week dates from week number
SQL
0 vote393 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
3 votes419 views1 answer
Mysql cli connect with password
SQL
0 vote347 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote370 views1 answer
T-sql email validation
SQL
6 votes346 views2 answers
Sql display max value
SQL
0 vote335 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote389 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote365 views1 answer
Two inner joins sql
SQL
1 vote393 views1 answer
Create new table from old table
SQL