forum

Home / DeveloperSection / Forums / auto increment by store procedure

auto increment by store procedure

Pawan kumar260114-Mar-2011

sir  i used this SP but Not autoincement

ALTER PROCEDURE dbo.AutoIncrement(@EmpName varchar(25),@Fathername varchar(25),@Address nvarchar(50),
@Phone nvarchar(12),
@Sex varchar(8),
@MaterialStatus varchar(10))
as
Declare @AEmpId int
select @AEmpId=count(EmpId)from TblEmpReg
IF(@AEmpId='0')
BEGIN
SET @AEmpId='1'
END
SELECT @AEmpId=max(@AEmpId)+1 FROM TblEmpReg
Insert into TblEmpReg(EmpId,EmpName,Fathername,Address,Phone,sex,MaterialStatus)values(@AEmpId,@EmpName,@Fathername,@Address,@Phone,@sex,@MaterialStatus)


Updated on 15-Mar-2011

Can you answer this question?


Answer

1 Answers

Liked By