Interested to Buy Any Domain ? << Click Here >> for more details...
Questions on identity?
- 2 Answers
- 6915 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 is difference between stored procedure and user defined function?
What are the different authentication modes in sql server?
How to enter unicode character string literals in ms sql server?
What number aggregate functions are accessible there in sql?
What is the basic functions for master, msdb, tempdb databases?
What are key constraints?
can we call stored Procedure in Function in Sql Server 2000 and vice versa.
3 Answers C3I, eSoft, iPRO Solutions, Wipro,
Tell me about builtinadministrator?
What is difference between temp table and cte?
What are the types of resultset?
What is database replication?
What is dbcc command in sql server?
-
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)
