Auto Increment

Auto increment allows the database to assign a unique number or value to be assigned to a record when new data is inserted into the table.  This is often used as a default primary key for lookup tables or where it is difficult to identify a natural key. In SQL Server,...