Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Questions on identity?

Question Posted / guest

Answers were Sorted based on User's Feedback



Questions on identity?..

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

Questions on identity?..

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

Post New Answer

More SQL Server Interview Questions

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

How can a user-defined datatype be created?

0 Answers  

What is a result set object returned by odbc_exec()?

0 Answers  

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,




What is 5nf in normalization form?

0 Answers  

Explain primary key in sql server?

0 Answers  

What is SQL server agent?

2 Answers   HCL, SAP Labs,

What is implicit cursors?

0 Answers  

How to remove duplicate rows from table except one?

0 Answers  

What is replication and database mirroring?

0 Answers  

How to use subqueries in the from clause in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories