1. Auto-Increment Primary Key in SQL Server
   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