Auto-increment allows a unique number to be generated when a new record is inserted into a table. By default, the starting value for AUTO_INCREMENT is 1, and it will increment by 1 for each new record.
CREATE TABLE Person ( ID int Identity(1,1) Primary Key, LastName varchar(255) Not Null, FirstName varchar(255), Address varchar(255), City varchar(255) )