Questions on identity?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we get count of the number of records in a table?

544


between cast and convert which function would you prefer and why?

532


How to find the service pack installed? : sql server database administration

546


What is normalization and its types?

532


What is best institute to Learn DotNET And SQL in chennai?

1688






How to drop existing indexes in ms sql server?

585


what are acid properties? : Sql server database administration

490


Explain sql server service broker?

510


Do you know what are different types of replication in sql server?

508


Is BCNF better than 2NF & 3NF? Why?

616


what is blocking? : Sql server database administration

498


What is microsoft sql server?

538


What do you mean by an execution plan?

562


When is update_statistics command used?

581


optimization techinques

2194