Interested to Buy Any Domain ? << Click Here >> for more details...
Questions on identity?
- 2 Answers
- 7041 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / p.s jayagopal
Identity(or Auto Number) is a column which automatically
generates numeric values.It will be mainly used for a column
which is set as primary key and which doesn't allow null value.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What are the different types of stored procedures?
Explain syntax for viewing trigger?
Do you know what are various aggregate functions that are available?
Why I am getting this error when renaming a database in ms sql server?
What is a constant or literal in ms sql server?
What happens to a statement batch if there is a compilation error?
Explain about remote stored procedure?
Tell about MOM Tool(Microsoft Operator Manager)?
Difference between 2NF &3NF ?
What is an identity column in insert statements?
How does normalization work?
How to perform backup for certificates in sql server? : sql server security
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
