How to select recently updated row?
The only scenario I can find that no results would be returned is if no row was updated. Architecturally speaking if that is actually your code and I would not bother making Stored Procedures that simplistic, just embed the SELECT query in the original Stored Procedure. Due to how SQL works if you start to get more complex with your queries trying to use certain Object Oriented habits by turning every duplicated or close to duplicated query into a Stored Procedure call can quickly become troublesome.