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
Explain the ways to controlling cursor behavior?
What is the difference between upgrade and migration in sql server?
What are the reporting services components?
How to list all login names on the ms sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Difference between 2NF &3NF ?
How to defragment table indexes?
What are the dis_advantages of stored procedures, triggers, indexes?
What is difference between table aliases and column aliases? Do they affect performance?
How to define and use table alias names in ms sql server?
What are synonyms?
Is sql server 2016 free?
How do I start sql server?
what happens on checkpoint? : Sql server database administration
How to access the inserted record of an event?
