corbincreativecomputing (7/26/2012)
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBAs leave these at 1. A GUID column also generates unique keys.
Nimol
Programmer
Corbin Creative Databases, LLC, http://www.corbincreative.com[/quote%5D
Just to add to, Identity can have negative values as well.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter