Generate customized Auto Increment unique key in SQL Server

Question

So im using sqlserver 2012 and i create my webapplications using vbnet I want to dynamically autoincrease my unique id column with customized figures like 0001 0002 003 using vbnet

dharmendr · Accepted Answer

Refer below link and modify as per your requirementGenerate auto incremented id based on last string value using C in ASPNet

david.ee · Answer

Hello dharmendrI followed the link and auto increment based on last value works fine but there are quite a few concerns about that method in multiuser interfacesThe main concern is that if concurrent users insert data into the database the likelyhood of having duplicate auto increment number is highSo I made more search and found two options either using a computed persisted column or using a sequenceI chose using a sequence and implemented as follows CREATE SEQUENCE seqtest  AS INT  START WITH 1  INCREMENT BY 1  MINVALUE 1  NO MAXVALUE   NO CYCLE  CACHE 10And to call the sequence during insert  INSERT INTO mytablemyid firstnameVALUESNEXT VALUE FOR seqtest 39David39This works fine for meThanks

Generate customized Auto Increment unique key in SQL Server

Generate auto incremented id based on last string value using C# in ASP.Net

Company

Explore

Follow us

Contact Us