Obtaining the Last Inserted Identity in SQL Server

SQL Server identity columns allow a sequence of numbers to be generated so that a unique number can be applied for each new row in a table. As these values are produced automatically, it is sometimes necessary to retrieve an identity after creation.