Retrieve Last Updated Record

Question

Hi

How can i retrieve last updated EmpID form sql database.

Answer 1

You can use SCOPE_IDENTITY() after your insert or update statement.

UPDATE Foo SET column1 = 'newValue'
SELECT SCOPE_IDENTITY() AS [LastUpdatedID]

http://msdn.microsoft.com/en-us/library/ms190315.aspx