We need the latest record that is inserted or updated . For doing that we need to find the latest row that can be done with the help of scope identity
ALTER procedure [dbo].[sp_AddEmployee]
(
@EmpName varchar(80),
@EmpDesgnationId int,
@EmpDob date,
@EmpSal money,
@EmpDoj date,
@EmpEmail varchar(100),
@EmpManagerId int ,
@EmpLogUserName varchar(100),
@EmpLogUserPassword varchar(100)
)
as
begin
declare @EmpID int
insert into dbo.EmployeeDetails(EmployeeName,EmployeeDesignationId,EmployeeDob,EmployeeSal,EmployeeDoj,EmployeeEmail,EmployeeManagerId) values (@EmpName,@EmpDesgnationId,@EmpDob,@EmpSal,@EmpDoj,@EmpEmail,@EmpManagerId)
set @EmpID=SCOPE_IDENTITY()
insert into dbo.EmployeeLogin (EmployeeId,EmployeeLoginUserName,EmployeeLoginPassword) values (@EmpID,@EmpLogUserName,@EmpLogUserPassword)
end
This will return the latest employee inserted.
0 Comment(s)