Auto Identiy

Question

Dear Sir How to create employee id number auto increment number like EMP1001 give example script coding

shubhangi khandale · Answer

Hello Write following formula for this if u use sql server then to go this column property computed column specification then write formula ((''EMP+left([empID(5)))+convert([varchar][empid](0))) and is Persisted =yes

Pravin Ghadge · Answer

hi  try this: declare @temp as char(15) set @temp=(select max(right(Itemcode6)) + 1 from tblname where (left(itemcode3)='EMP' set @temp='EMP'+isnull(replicate(06-len(@temp))'')+@temp select isnull(cast(@temp as char(15))'EMP100001')