Retrieve Last Updated Record

Hi

How can i retrieve last updated EmpID form sql database.

From stackoverflow

• 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