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.

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 )

what is an extended stored procedure? : Sql server database administration

1 Answers  

---

Mention the different types of triggers?

1 Answers  

---

What is a non clustered primary key?

1 Answers  

---

What the class forname () does?

1 Answers  

---

What are the different types of locks in the database?

1 Answers  

---

What is equi join with example?

1 Answers  

---

optimization techinques

1 Answers   Wipro,

---

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

How to rebuild all indexes on a single table?

1 Answers  

---

What are temporal tables in sql server 2016?

1 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---