primary key with prefix sql

Cute Civet answered on July 7, 2021 Popularity 8/10 Helpfulness 2/10

answer primary key with prefix sql

primary key with prefix sql

Comment

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

Popularity 8/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: prefix primary-key sql

Link to this answer
Share Copy Link

Contributed on Jul 07 2021

Cute Civet

0 Answers Avg Quality 2/10

primary key with prefix sql

Contents

More Related Answers

primary key with prefix sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.