get the last updated record in sql server 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>;