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

do you know how to configure db2 side of the application? : Sql server database administration

0 Answers  

How will you optimize a stored procedure optimization?

0 Answers  

SQL Server Architecture ?

0 Answers   IBM, Sapient,

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,




What is sql sandbox in sql server?

0 Answers  

How would you choose between a clustered and a non-clustered index?

0 Answers  

Explain Geography datatype in SQL Server

0 Answers   Infosys,

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

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

0 Answers  

What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,

What is the difference between a function and a trigger?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories