Auto Increment ID

Question

Dear sir How to Generate ESPL170001 ID from Table ESPL+ YY(Year Last Two Digits)+0001 OUT PUT: ESPL170001

Dharmraj Thakur · Answer

Ohkay... Just Display current year instead of '17' declare @ no as varchar (10); --declare a variable set @ no = 'ESPL' + cast ( YEAR (GETDATE())%100 as varchar (2)) + '0001' ; --this value can be stored from anywhere even from any table select concat ( 'ESPL' ( cast ( SUBSTRING (@ no  5 len(@ no )) as int )+1)) as Id --incremented value

Manas Mohapatra · Answer

Try like below: DECLARE @tempESPL VARCHAR (10); SET @tempESPL = 'ESPL' + Right ( Year (getDate())+ 12) + right ( '0000' + convert ( varchar (4) id) 4); -- Id is incremental values like 1234 PRINT @tempESPL;

Joseph Thomas · Answer

Go through the following links: http://www.webcodeexpert.com/2015/08/auto-generate-auto-incremented-unique.html http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/

Dharmraj Thakur · Answer

You can use following query and you can manage your user defined incremented ID.... declare @ no as varchar (10); --declare a variable set @ no = 'ESPL170001' ; --this value can be stored from anywhere even from any table select concat ( 'ESPL' ( cast ( SUBSTRING (@ no  5 len(@ no )) as int )+1)) as Id

yesubabu k · Answer

Sir Next to ESPL Needed Year Last two digits