Interested to Buy Any Domain ? << Click Here >> for more details...
Questions on identity?
- 2 Answers
- 7009 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 |
How to execute multiple stored procedures at one time in sql server?
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"
How to test subquery results with the exists operator?
What is the cpu pressure?
What is the importance of concurrency control?
Does sql server 2000 clustering support load balancing?
What is the use of MOVE keyword in restore command
Explain the benefits of user-defined functions?
What is the difference between a local and a global temporary table?
Can you move the resources after pausing the node? : sql server database administration
If the job running very slow what is the action you do
What is a trigger 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)
