you can use trigger in this scenario. I'm assuming empid is not an identity column and u're manually inserting data in that column.

===================================

create table employees

(

empid int,

empcode varchar(10),

ename varchar(100)

)

create trigger trg_empCode

on Employees

after insert

AS

update employees set employees.empcode= 'e'+right('0000'+cast(inserted.empid as varchar),5) from inserted

INNER JOIN employees on employees.empid=inserted.empid

insert into employees(empid, ename)

select 1, 'pradeep'

insert into employees (empid, ename)

select 2,'polo'

union all

select 3, 'csit'

union all

select 4, 'singh'

select * from employees

OUTPUT

--------

1e00001pradeep

2e00002polo

3e00003csit

4e00004singh

=================================================

Is this what you want?