Is it possible to retrieve table records both before insert and after update done using triggers

 Create table Emp (
EmpId  varchar(5),
EmpName varchar(40)
)
Create table EmployeeDetailsHist (
EmpId  varchar(20)
, EmpName varchar(40)
, HistoryDate datetime 
) 

create TRIGGER EmpAfterUpdate
ON Emp
AFTER UPDATE
AS
IF ( UPDATE (EmpId) OR UPDATE (EmpName) )
BEGIN
INSERT INTO EmployeeDetailsHist (EmpId, EmpName, HistoryDate)
select EmpID, EmpName, getdate()
from deleted ;
END;

Update Emp set EmpName = 'Raj' where EmpId = '1'

select 
'Current' as Origin, EmpId, EmpName from Emp 
union all
select 'History' as Origin, EmpId, EmpName from EmployeeDetailsHist

Status    EmpId   Name 
------------------------
Current	1	Raj
Current	2	Surya
History	1	Kamal