Interested to Buy Any Domain ? << Click Here >> for more details...
Questions on identity?
- 2 Answers
- 7117 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 |
Describe and explain about SQL native client?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is the difference between a function and a trigger?
What is a partitioned view?
What is full outer join in sql server joins?
What is the dbcc command and why is it used?
How to write query to Delete the records in child table and corresponding records in parent table
What is the difference function and stored procedure?
What is Dependency Injection and provide example?
What is a non clustered primary key?
What are dml triggers and types of dml triggers?
What happens if the update subquery returns multiple rows in ms sql server?
-
Oracle (3253) - 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)
