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

What are sql servers used for?

721


Does index slows down insert statements?

750


How efficient you are in oracle and SQL server?

806


Explain what is it unwise to create wide clustered index keys?

702


what's the maximum size of a row? : Sql server database administration

737






How to transfer data from a cursor to variables with a "fetch" statement?

765


How to scale out a federation by Sql statement?

110


Explain few of the new features of sql server 2008 management studio

683


What is a database in ms sql server?

735


What is change tracking in sql server?

705


How to create a view using data from another view?

728


What is default constraint in ms sql server?

712


What is a non equi join?

733


Explain about builtinadministrator?

768


What is pivot and unpivot?

775