get last inserted id ms sql code example

Example: sql get last ID

SELECT MAX(id) FROM <tablename>