if you want to insert data with new id then use following storedProcedure,
CREATE PROCEDURE [dbo].[InsertEmployee]
@FirstName varchar(50),
@LastName varchar(50),
@dob datetime,
@Country varchar(50)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @empcode varchar(50)
SELECT TOP 1 @empcode = 'eoo'+ CAST(SUBSTRING(empcode,4,LEN(empcode))+1 AS VARCHAR(100))
FROM Emp1 ORDER BY empcode DESC
INSERT INTO Emp1 (empcode ,fname , lname , dob , Country)
VALUES (@empcode ,@FirstName, @LastName, @dob, @Country)
END