Auto-Increment Primary Key in SQL Server Management Studio 2012
Understanding the Concept:An auto-increment primary key in SQL Server is a unique identifier that automatically increases by a specified value (usually 1) for each new record inserted into a table