1.

Explain Identity In Sql Server?

Answer»

Identity (or Auto-Number) 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.

Identity (or Auto-Number) 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.



Discussion

No Comment Found