How to change the primary key to auto increment in SQL Server - Quora
Using auto-increment with Microsoft SQL database tables - Microsoft SQL - Hostek Community
DotNet Solution: Auto Increment Id in Sql Server
sql server - Auto incrementing a foreign key value the same as the primary key of the parent table in SQL when inserting data? - Database Administrators Stack Exchange