IDENTITY columns in SQL Server

The IDENTITY columns are auto incrementing columns provided by SQL Server. There can only be one IDENTITY column per table. SQL Server will take care of incrementing this column automatically.

Read more at http://www.dotnetfunda.com/articles/article753-identity-columns-in-sql-server-.aspx

Author: Chikul