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

How many triggers you can have on a table?

0 Answers  

Explain how many normalization forms?

0 Answers  

What is the difference between a local and a global temporary table?

0 Answers  

What is compound operators?

0 Answers  

What are temporal tables in sql server 2016?

0 Answers  




What are the types of resultset?

0 Answers  

What is bcp? When does it used?

0 Answers  

plz send every query in sql server2000

1 Answers   Infosys,

What is partition in sql server?

0 Answers  

Tell me what do we need queues in sql service broker?

0 Answers  

Explain about link server in sql server?

0 Answers  

How to create a new table in a given schema?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories