What is Identity in SQL Server?

What is Identity?
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID column also generates numbers; the value of this cannot be controlled. Identity/GUID columns do not need to be indexed.

Comments

Popular posts from this blog

Google to FTS Syntax Cheat Sheet

Reading lines from a file using SQL Server

Schema Binding and Indexed Views in SQL Server