In this article, we will see how to use @@IDENTITY and SCOPE_IDENTITY() in SQL Server 2012.
www.c-sharpcorner.com