Trigger Creation on Tables with Magic Table

I am going to create a Trigger on Table tblRaj.
This Trigger wil help to Insert the data in AUDIT Trail Table on each insertion and deletion.
AUDIT Trail Table tblRaj_AuditTrail has same structure (Except these columns
AuditTrailId,OperationType, OperationDate,ApplicationUser,DatabaseUser).
Now The Syantax is as Follows :-


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE TRIGGER [dbo].[trg_tblRaj_AuditTrail] on [dbo].[tblRaj] for insert, update , delete

AS

DECLARE @CONTEXT_INFO int

SELECT @CONTEXT_INFO=cast(context_info as int) FROM sys.dm_exec_requests WHERE session_id = @@SPID

if exists (select * from inserted) and exists (select * from deleted)

BEGIN

INSERT INTO tblRaj_AuditTrail select 'U', getdate(), @CONTEXT_INFO,system_user,* from inserted

END

else if exists (select * from inserted)

BEGIN

INSERT INTO tblRaj_AuditTrail select 'I', getdate(), @CONTEXT_INFO,system_user,* from inserted

END

else

BEGIN

INSERT INTO tblRaj_AuditTrail select 'D', getdate(), @CONTEXT_INFO,system_user,* from deleted

END