sql server identity

Question

Table : info Id Name ________ L01 xxx L02 yyy L03 zzz L04 aaa how to do this kind of indentity for (Id) column.....is it possible in sql server??

Satyapriya Nayak · Answer

CREATE TABLE Employee ( ID VARCHAR(50)  Name VARCHAR(255) ) Stored Procedure CREATE PROCEDURE dbo.AutoIncrement_Id ( @Name VARCHAR(255) ) AS DECLARE @Max INT  @ID VARCHAR(10) IF NOT EXISTS(SELECT ID FROM Employee) BEGIN SET @ID = 'L01' INSERT INTO dbo.Employee(IDName) VALUES(@ID @Name) END ELSE BEGIN SELECT @Max = CONVERT(INT SUBSTRING(CONVERT(VARCHAR(10)ID) 2 10)) FROM Employee SET @ID = 'L' + RIGHT('0' + CONVERT(VARCHAR(10) @Max + 1) 5) INSERT INTO dbo.Employee(IDName) VALUES(@ID @Name) END Execution of Stored Procedure EXEC dbo.AutoIncrement_Id 'Raj' EXEC dbo.AutoIncrement_Id 'Ravi' EXEC dbo.AutoIncrement_Id 'Rahul' Display result SELECT * FROM dbo.Employee

Jignesh Trivedi · Answer

hi Please refer my article http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/ hope this will help you.

Sanjeeb Lenka · Answer

hi refer to this link http://dotnetadda.blogspot.in/2010/05/auto-generate-alphanumeric-ids-in-sql.html http://www.sqlservercurry.com/2011/11/generate-alphanumeric-identity-column.html