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 is sub-query in sql server?
Write SQL queries on Self Join and Inner Join.
How to use clusters?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Can You Use Data Mining Models In Ssrs?
whats new about truncate in sql server 2008?
What is transaction server isolation?
Can we perform backup restore operation on tempdb? : sql server database administration
What are the differences between stored procedure and the dynamic sql?
How to concatenate two binary strings together?
What is the difference between upgrade and migration in sql server?
How can a user-defined datatype be created?
How to delete all rows with truncate table statement in ms sql server?