Last inserted Row

Another method for finding Last inserted row is

ALTER PROCEDURE [dbo].[SR_SelectProjectCodeLastInserted]
AS
BEGIN
SET NOCOUNT ON
SELECT TOP 1 *
FROM Project
ORDER BY Project_Code DESC
SET NOCOUNT OFF
END