<p>say I want to find the latest added rows (UPDATE by any user, not necessarily the one which is executing UPDATE)  in XX table.</p>

Please refer to SQL Docs & look for OUTPUT clause (that you can use with UPDATE/INSERT to get the affected records).
http://msdn.microsoft.com/en-us/library/ms177564.aspx