Using session value in Trigger in SQL Server

Are you storing Value of session in ActionBy in EPaper table when you perform insert on EPaper table.

You first need to store session value in column of EPager. And in trigger you can get saved value of session from perticular column by referring from Inserted table as current record Inserted/Updated in Epager table.

Check the below test query and try to implement as per your table and column string logic if you are need to store the session value in ActionBy in Epaper_log table then you must sure you are storing session value in Epage in ActionBy column.

If you want to store in new column the add column in Epaper and in Epaper_log and first save session value in Epaper and you can access the column value in trigger and save in Epaper_log table.

SQL

CREATE TRIGGER EpaperTrgrUpdate
       ON EPaper
AFTER INSERT , UPDATE 
AS
BEGIN
       SET NOCOUNT ON;
  
       DECLARE @EpaperId INT
       DECLARE @Date datetime
       DECLARE @ActionBy nvarchar(50)
       DECLARE @Action varchar(50)
       DECLARE @SessionValue VARCHAR(MAX)


       SELECT @EpaperId = i.SrNo, @Date = i.date, @ActionBy = i.ActionBy , @SessionValue = i.SessionColumn
       FROM Inserted i
  
       IF UPDATE(IMG)
       BEGIN
              SET @Action = 'Image Updated'
       END
  
       IF UPDATE(Date)
       BEGIN
              SET @Action = 'Date Updated'
       END
 
       INSERT INTO Epaper_Log
       VALUES(@EpaperId, @Date, @Action, @ActionBy,@SessionValue)
END