What is an Identity Column?
If a column is marked as an identity column, then the value for this column are automatically generated, when you inserted a new row in the table.
Create an Identity column
Create a table tblemployee, this statement marks PersonId as an identity column with seed = 1 and Identity Increment = 1. Seed and Increment values are optional. If you do not specify the identity and seed they both default to