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

Explain about system stored procedure?

609


mention different types of relationships in the dbms?

515


How to write a query with a full outer join in ms sql server?

568


Define Unique Key?

602


What is a select query statement in ms sql server?

585






Is oracle faster than sql server?

559


What is the difference between stored procedure and functions?

606


What command do we use to rename a database?

622


Explain primary key and foreign key constraints?

527


List some case manipulation functions in sql?

601


What is collation sensitivity? Explain different types.

559


How to query multiple tables jointly?

564


Do you know data definition language, data control language and data manipulation language?

640


what is an index? : Sql server database administration

529


How much memory that we are using in Logshipping Concept?

1372