Cacher is the code snippet organizer for pro developers

SELECT
	MAX(IDENTITYCOL) AS MaximumIdentity
FROM
	[konnex].[dbo].[AppContacts]

SELECT Auto_increment FROM information_schema.tables WHERE table_name='the_table_you_want'

SELECT row 
FROM table 
WHERE id=(
    SELECT max(id) FROM table
    )