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 are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What should be the fill factor for indexes created on tables? : sql server database administration
What are the database roles? : sql server security
Explain the relational database management system (rdbms)?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is a unique key constraint?
Differentiate between a local and a global temporary table?
What is user-defined functions? What are the types of user-defined functions that can be created?
Explain having clause?
What is molap and its advantage? : sql server analysis services, ssas
How to replace null values in expressions using isnull()?
What is scrollable cursor?
What is left outer join in sql server joins?
How to add additional conditions in SQL?
Explain indexing and what are the advantages of it?
