How to generate employee ID in c# asp.net

DECLARE @EMPID INT

SET @EMPID = ISNULL(@EMPID,(SELECT MAX(EMPID) FROM tbl_Employee) + 1)

Insert into tbl_Employee (EMPID,EMPFirstName,EMPLastName, .....)

Values(@EMPID, .....)

Try to se procedure as in the following way -

Create Procedure InsertEmpDetails
(
@Name NVARCHAR(100),
)
AS
Begin
DECLARE @ID INT
SET @ID = ISNULL(@ID,(SELECT MAX(Id) FROM tblEmployee) + 1)

Insert into tblEmployee (ID, Name, ...)
Values(@ID, )
End

Hi,

Hi

I want Code for generate Employee ID Card for Register user in c# asp.net

Hi,

select 'FHMS' + max(SUBSTRING ( employeeId ,5 , 5 ))+1 as nextkey from employeemaster