Interested to Buy Any Domain ? << Click Here >> for more details...
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 the recommended total size of your memory optimized tables?
What are the advantages of user-defined functions over stored procedures in sql server?
how to take backup bcp out for a column in table in sql server?
How to delete exactly duplicate records from a table?
What command is used to delete a table from the database in the sql server and how?
What are the database objects? : SQL Server Architecture
Why should we go for stored procedures? Why not direct queries?
Define candidate key, alternate key, and composite key.
What is the Main Difference between ACCESS and SQL SERVER?
How many types of attribute relationships are there? : sql server analysis services, ssas
How do you create an execution plan?
How to create a scrollable cursor with the scroll option?
Write an sql query for deleting duplicate rows?
What stored by the master? : sql server database administration
How you provide security to cube? : sql server analysis services, ssas
