The way I would do it is simple: add a DATETIME column called InsertAt and set it's default value to GETDATE()
Then, all you have to do is:
SELECT TOP 1 * FROM MyTable ORDER BY InsertAt DESC
Because you have given it a default, no other code should need changes.