CODE EXAMPLE FOR SQL

get last updated row sql server

UPDATE TableName
SET column1 = 1,
column2 = 2
OUTPUT DELETED.*
WHERE <condition>;