retrieve last updated record sql code example
Example: get last updated row sql server
UPDATE TableName
SET column1 = 1,
column2 = 2
OUTPUT DELETED.*
WHERE <condition>;
UPDATE TableName
SET column1 = 1,
column2 = 2
OUTPUT DELETED.*
WHERE <condition>;