SQL AUTO INCREMENT a Field - W3Schools

Very often we would like the value of the primary key field to be created ... The SQL statement above would insert a new record into the "Persons" table. ... The MS SQL Server uses the IDENTITY keyword to perform an auto-increment feature.

www.w3schools.com