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 different types of statement?
How to delete duplicate rows?
Write a program to fetch first 10 records from a file?
what does the automatic recovery do? : Sql server administration
Do you know the policy based administration feature of sql server 2008?
What is the impact on other user sessions when creating indexes?
What is difference between count (*) and count 1?
What do you understand by SQL*Net?
What is a data source or ds? : sql server analysis services, ssas
What do we have to check in database testing?
How to use wildcard characters in like operations in ms sql server?
How does the report manager work in SSRS?
How to compare the top two records using sql?
How to list all schemas in a database?
what is a traditional network library for sql servers? : Sql server database administration
