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
Is the primary key column of a table an index in ms sql server?
How can you check the level of fragmentation on a table?
how would you store your query in an SSRS report or a Database server?
What is cte (common table expression)?
What is the sql case statement used for?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What are the extra roles available in msdb? : sql server security
What are the types of sql server?
What is the importance of a recovery model?
Mention a few common trace flags used with sql server?
Define inner join? Explain with an example?
What is the purpose of indexing?
Scalability, Availability, Integration with internet, etc.)?
What are sql server procedures?
What are the characteristics of modern DBMS?
