IDENTITY vs UNIQUEIDENTIFIER COLUMN IDENTITY Sl No Advantage Disadvantage 1 Identity column stores numeric values. Numeric value column have better performance in joins, indexes and […]
IDENTITY property Identified column can be implemented using IDENTITY property. While specifying IDENTITY column, you specify SEED and ARGUMENT. SYNTAX : IDENTITY [ (seed , increment) […]