Get the last inserted id

You can get last inserted id in SQL Server

  DECLARE @Last_Insterted_id integer=0       

 SELECT @Last_Insterted_id=IDENT_CURRENT('tablename')