i created a procedure what u given..i will try what you given in your article ..but empcode is not generated automatically...here is the procedure....pls check its correct or not...
CREATE PROCEDURE [dbo].[getnextid1]
@Empcode varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@dob datetime,
@Country varchar(50)
AS
BEGIN
SET NOCOUNT ON;
select top 1 @empcode=empcode from emp1 order by empcode desc
select @Empcode
INSERT INTO Emp1 (empcode ,fname , lname , dob , Country)
VALUES (@empcode ,@FirstName, @LastName, @dob, @Country)
END