HOW TO GENERATE UNIQUE ID(CHARACTER + NUMBER) FOR CUSTOMER IN SQL SERVER

HERE IN THIS SQL Tutorial WE WILL GENERATE UNIQUE ID(CHARACTER + NUMBER) FOR CUSTOMER IN SQL SERVER
HERE WE REQUIRED
SQL SERVER MANAGEMENT STUDIO
USING CAST,RIGHT,PERSISTED FUNCTIONALITY
TABLE AND DATABASE

[@juliedecarufel3818]

How can we do that but without having the column ID and Prefix in our table when we do a select * in the table?

[@22199610]

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY(1,1) NOT NULL, booking_Id AS ('B' + RIGHT('00' + CAST(ID AS VARCHAR(7))' at line 2
Getting error while implementing the same

[@infomaxviv7008]

Good Content

[@tiffanyurigirlsg3185]

Finally I found this tutorial!

[@binhnguyenam2546]

Thanks for your help, but I have a question: How can I get the Computed column (CustomerNo) is the primary?. I know that the computed column can't be get the primary key.

[@Evolving_echo]

Its nice, but one question what to do if I want to generate Custom id by merging 3 columns with a auto increment id

[@meesaqhussain3340]

What is datatype of "CustomerNo"? When I pass a varchar CustomerNo to stored procedure it show this error ""Msg 245, Level 16, State 1, Procedure GetByName, Line 17
Conversion failed when converting the varchar value 'Emp1' to data type int.
""

[@manasnikam6237]

Awesome !!!!! Great !!!!

[@NETTutorialsEasyWayToLearn]

Thanks

[@dondavisarroyo5625]

Thank you mate!

[@suryakanttakke3086]

after long back son

[@NETTutorialsEasyWayToLearn]

Thanks

[@chandanv8430]

Can u please do this for only integer

[@shreyaskarkera2329]

Good comeback

[@NETTutorialsEasyWayToLearn]

Thanks

[@anandprajapati1612]

puri table show karate bhai mujhe EmpId pr chahiye tha na ki EmpNo pr

[@tenssports1069]

is this queary is applicable for sql oracle? if not what?

[@NETTutorialsEasyWayToLearn]

Hey tenssports,Thanks For Asking Me Dout,Here Is The Solution Below
Step 1 :- Create Database
Create DataBase Demo
Step 2 :- Create Table
Create table Test
(
id int not null,
PerFix varchar(3),
result varchar(50),
Primary Key (id)
);
Step 3 :- Create Sequence
Create Sequence id minvalue 1 start with 1 cache 10;
*Here You Can Start With Any Number
Step 4 :- Insert Data
insert into Test values(id.nextval,'SBI','SBI'+id.nextval);
Step 5 :- Select Query
Select *From Test
Output :
id PerFix result
1 SBI SBI1

[@mirzahaseeb4276]

Thanks.

[@mohamedzakaria9124]

Thank u so much

[@infomudrahome3794]

how can we do it for MYSQL ?

[@muhammadismailmehtab]

Hi sir how create I'd no with alphabet like M1,M2,M3

[@RatulKoleyYT]

at the prefix place right whatever const value u needed like here 'M'

[@younessmaknous3959]

code in mysql please

[@Buciasda33]

Good, now hack and fake the Unique ID...
I have to merge some recovered database, initially corrupt, with a new one and still have the program think I haven't messed with it's database :)

[@sgz7748]

this is really Good . i appreciate you for this kind of information.

[@HeyItzMaeve]

thank you i have been searching for this the whole day !!

[@gautamkarkera5246]

Good one

[@NETTutorialsEasyWayToLearn]

Thanks