CREATE TRIGGER [dbo].[TriggerName] ON [dbo].[TableName]  FOR UPDATE AS


// declare id variable first;

DECLARE @ID int

//set it in the begin section. 
BEGIN

	SET @ID = (SELECT IssueID FROM inserted)
END

*inserted is table from where we are querying the last updated id.

How to get recent updated record Id in the triggers

SQL