Answer: Identity is column that automatically generates numeric values, it is increamented by 1 by default but it can be set also.
Example:
Create table tabName
(
ID INT IDENTITY(1,1) NOT NULL,
NAME VARCHAR(20) NULL
)
Asked In: Many Interviews |
Alert Moderator