Random Employee Id

 

You can do this stuff from sql server using after insert trigger.

 
Add one extra field EmployeeId in your table and apply this trigger(inside attachment) on your table

 

For example download this attachment.

 

Or paste below code.

 

CREATE TRIGGER [dbo].[employeeid_after_insert] ON [dbo].[YourTableName]
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @lastInsertedid INT

SET @lastInsertedid = ( SELECT IDENT_CURRENT('YourTableName')
)
--update employeeid field after value insert into table

UPDATE YourTableName
SET EmployeeId = 'EMP' + CONVERT(VARCHAR(50), YEAR(GETDATE()))
+ CONVERT(VARCHAR(50), @lastInsertedid)
WHERE Id = @lastInsertedid
END; 

Hi Vaibhav 

 

Better you need to store the id after year in a separate column . why because then only you can generate  a sequence number or id

 

 eg:

          EMP2014"10000"                                      10001 Next no

          EMP2014"10001"                                      10002  Next No

          EMP2014"10002"                                      10003   Next No         increase +1 in the same column