Answers for "sql get last update identity value"

sql get last ID

SELECT MAX(id) FROM <tablename>

Posted by: Guest on May-21-2021

get last updated row sql server

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

Posted by: Guest on May-14-2021

Code answers related to "sql get last update identity value"