2 April 2013

Find SQL last inserted row without using IDENTITY COLUMN

SELECT TOP 1 FirstName , row_number() over ( order by ( SELECT 2 ) ) AS ROWNUMBER FROM FirstNameandLastName ORDER BY ROWNUMBER DESC