Answer Posted / magu
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.
Syntax :
IDENTITY ( seed, increment )
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what are the different stages of Report Processing?
what are constraints? Explain different types of constraints? : Sql server database administration
Write a SQL command to insert and update only a particular field?
What is BCP? When does it used in sql server 2012?
What are the disadvantages of using querystrings to send data from one page to another?
What is the maximum size of column in sql server?
What are the difference between “where” and “having” clause in sql server?
Why I am getting this error when renaming a database in ms sql server?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is a sql join?
What to perform pattern match with the like operator?
What's the information that can be stored inside a bit column?
Define compound operators?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Explain syntax for dropping triggers?