What is Identity?

 Posted by Rajni.Shekhar on 4/23/2012 | Category: Sql Server Interview questions | Views: 1709 | Points: 40
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 

Comments or Responses

Login to post response