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

7 votes207 views1 answer
Mysql iif
SQL
0 vote216 views1 answer
Mysql root localhost run
SQL
0 vote216 views1 answer
Sql server convert to guid
SQL
4 votes191 views1 answer
Postgresql show current database
SQL
0 vote242 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote199 views1 answer
Django how to get query result count
SQL
0 vote210 views1 answer
To_date sql
SQL
0 vote196 views1 answer
Mysql add comment to column
SQL
0 vote240 views1 answer
Into operator in sql
SQL
0 vote204 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL