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 the different types of replication you can set up in sql server?

530


List the data types available in mssql?

531


Explain identity in sql server?

566


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1405


How to get the query of a table in sql server?

504






Characterize join and name diverse sorts of joins?

533


Explain indexes disadvantages?

551


Why I am getting this error when renaming a database in ms sql server?

537


How to find table changes in sql server?

663


How fixed length strings are truncated and padded?

552


If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

558


What are scalar functions in sql?

612


How can we rewrite sub-queries into simple select statements or with joins?

527


Which tools are available to manage SQL Azure databases and servers?

93


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

616